Re: WebObjects with Postgres 'Serial' column as the PK
Re: WebObjects with Postgres 'Serial' column as the PK
- Subject: Re: WebObjects with Postgres 'Serial' column as the PK
- From: Giorgio Valoti <email@hidden>
- Date: Fri, 7 May 2004 09:42:16 +0200
On 07/mag/04, at 05:53, Arturo Pirez wrote:
On May 6, 2004, at 11:32 PM, Andy Satori wrote:
The problem is when I use EOModeler to read the existing Postgres
database, I can connect to it, and build the model, but WebObjects
can't seem to do anything with it because of select syntax errors in
the WO generate SQL, and primary key format issues with the serial
column as PK.
Standard issue questions: What version of WO? What version of
Postgresql (pgSQL)? Which pgSQL plugin are you using?
IIRC, the SERIAL datatype is not directly supported. But if you use
the Project Wonder Postgresql plugin
(http://cvs.sourceforge.net/viewcvs.py/wonder/Wonder/PlugIns/
PostgresqlPlugIn/) it will use sequence generators to create pk.
Also, It should be noted that the serial data type it's just a
shorthand for:
int4 NOT NULL default nextval( 'tablename_colname_seq' )
HTH
--
Giorgio Valoti
--------------
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.