PostgreSQL SQL generation
PostgreSQL SQL generation
- Subject: PostgreSQL SQL generation
- From: Clark Mueller <email@hidden>
- Date: Fri, 26 Jan 2007 09:42:50 -0700
Hi all,
I have been tinkering with PostgreSQL, and would like to try using it
with a WO project. I'm running into an odd problem when trying to
generate SQL out of Entity Modeler, which is that commands like this
sequence of commands fail:
CREATE TABLE customer_note (customer_id int4 NOT NULL, date
timestamp NOT NULL, details varchar(1000) , id int4 NOT NULL,
is_call varchar(5) , is_closed varchar(5) , is_email varchar(5) ,
is_face_to_face varchar(5) , is_note varchar(5) , subject varchar
(255) NOT NULL, user_id int4 NOT NULL);
CREATE SEQUENCE customer_note_seq;
CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT SETVAL
('customer_note_seq', (SELECT MAX(id) FROM customer_note));
DROP TABLE EOF_TMP_TABLE;
Specifically, when it hits the "DROP TABLE EOF_TMP_TABLE", it says
that eof_tmp_table does not exist. However, if I take the SQL from
Entity Modeler and run it as a script against the database, it works
perfectly. I'm using the Wonder plugins and prototypes, and the JDBC
driver included with PostgreSQL 8.2.1.
URL: jdbc:postgresql://localhost/pgtest
Driver: org.postgresql.Driver
Plugin: PostgresqlPlugIn
Any idea what's up?
Thanks,
Clark
_______________________________________________
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