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: "Goh Keng Boon" <email@hidden>
- Date: Fri, 7 May 2004 15:47:04 +0800 (SGT)
In my case, all the PK will have a matching sequence, which is generated by
the EOModeler. If you are reading existing one, may be you want to create
all the matching sequence number yourself.
One example, my table name : user, i have a userid as PK, and there will be
a sequence called user_seq created by EOModeler.
I'm using plugin from hexdreamz
cheers.
KB
> 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.
>
> ----
> WO in philadelphia - wanna cheesesteak with that?
> Please visit webobjects.meetup.com.
> _______________________________________________
> 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.
_______________________________________________
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.