Re: Error: table "eof_tmp_table" does not exist.
Re: Error: table "eof_tmp_table" does not exist.
- Subject: Re: Error: table "eof_tmp_table" does not exist.
- From: Pascal Robert <email@hidden>
- Date: Tue, 15 Nov 2011 16:38:40 -0500
Le 2011-11-15 à 16:25, Kevin Spake a écrit :
> yes, that was the exact message. Good to know I can ignore it.
>
> BTW, is postgresql not supported as well as mysql in WO? is anyone using Postgresql 9.1 with WO and Wonder?
PostgreSQL is well supported, and as many people are using it with WO as MySQL:
http://wiki.objectstyle.org/confluence/display/WOCOM/WOCommunity+2011+Organization+Survey+Results+Preview
Which database systems does your organization use with WebObjects?
2011 2010
MySQL 42% 39%
PostgreSQL 44% 39%
Oracle Database 28% 27%
FrontBase 20% 22%
MS SQL Server 14% 12%
>
> On Nov 15, 2011, at 1:15 PM, Paul Hoadley wrote:
>
>> Hi Kevin,
>>
>> Just as an aside:
>>
>> On 15/11/2011, at 2:55 PM, Kevin Spake wrote:
>>
>>> I'm no longer getting the "user" error, however, I now get:
>>>
>>> "Failed to generate SQL. ERROR: table "eof_tmp_table" does not exist.
>>
>> Is that the precise error message? The SQL generated by the PostgreSQL plugin has been very slightly wrong for quite some time, and you usually see this:
>>
>>> ERROR: relation "eof_tmp_table" already exists
>>
>> (The plugin should probably add "ON COMMIT DROP" to all those temporary table creation statements.)
>>
>>> There was an error, do you want to cancel the rest of the script?"
>>>
>>> i chose to continue and it looks like the SQL completed.
>>
>> They are safe to ignore, and the SQL will complete.
>>
>>
>> --
>> Paul.
>>
>> http://logicsquad.net/
>>
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden