Yeah this is actually expected right now ... I just hadn't gotten
around to adding an option. If you execute the SQL from inside of EM,
it works because transactions are setup differently than if you copy
and paste the code for use in other places. EM would fail with the
inverse problem previously. I'm really curious if PG has to actually
create those temp tables to begin with.
ms
On Mar 29, 2008, at 11:02 PM, Miguel Arroz wrote:
> Hi!
>
> I installed all the WO 5.3 + Eclipse + WOLips + Wonder stuff on my
> new MBP (thank you all who recommended the 17 HD, it's AWESOME!).
>
> Anyway, I'm having a problem when generating SQL. The PostgreSQL
> sequence SQL code is lacking the "DROP TABLE EOF_TMP_TABLE" line.
> So, when I run the SQL code I get this:
>
> ALTER TABLE
> CREATE SEQUENCE
> ERROR: relation "eof_tmp_table" already exists
> ALTER TABLE
> CREATE SEQUENCE
> ERROR: relation "eof_tmp_table" already exists
> ALTER TABLE
> CREATE SEQUENCE
> ERROR: relation "eof_tmp_table" already exists
> ALTER TABLE
> CREATE SEQUENCE
> ERROR: relation "eof_tmp_table" already exists
> (...)
>
> Comparing with the latest working SQL code in the project SVN, I
> see the only difference is the DROP TABLE EOF_TMP_TABLE lacking on
> the current generated SQL.
>
> Is this a bug in the recent WOLips version, or did I screw anything
> up in the installation? I *think* I moved all the WO 5.4 libs out of
> the way. I'm using PgSQL 8.3.1, the latest version, with also the
> latest version of the JDBC driver. WOLips stable, and Wonder from
> CVS about 3 nights ago.
>
> Yours
>
> Miguel Arroz
>
> Miguel Arroz
> http://www.terminalapp.net
> http://www.ipragma.com
>
>
>
This archive was generated by hypermail 2.0.0 : Sun Mar 30 2008 - 17:08:11 EDT