Re: Primary key field generation with postgres

2008-03-27 Thread Adam Hardy
You might want to make that schema.toLowerCase() Postgres diverges from the JDBC spec by making everything lower case and it won't find an upper case schema. I raised that as a bug with postgres and their developers told me it was unlikely to be changed any time soon. roger.keays on 27/03/0

RE: Primary key field generation with postgres

2008-03-27 Thread roger.keays
Here is my patch for OpenJPA 1.0.2. You might prefer to move the code to the superclass though. Index: openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java === --- openjpa-jdbc/src/main/java/org/apache/openj

RE: Primary key field generation with postgres

2008-03-27 Thread roger.keays
Marc LaPierre wrote: > > It seems like JPA isn't finding your sequence in the ves schema. > > Are you sure that your sequence exists in Postgres? > Are you able to run "select currval('user_id_seq')" from the sql > console? > Was this ever resolved? In this case SELECT currval('user_id_seq')

RE: Primary key field generation with postgres

2008-02-14 Thread Marc LaPierre
E: Primary key field generation with postgres It seems like JPA isn't finding your sequence in the ves schema. Are you sure that your sequence exists in Postgres? Are you able to run "select currval('user_id_seq')" from the sql console? Marc -Original Message--

RE: Primary key field generation with postgres

2008-02-14 Thread Marc LaPierre
It seems like JPA isn't finding your sequence in the ves schema. Are you sure that your sequence exists in Postgres? Are you able to run "select currval('user_id_seq')" from the sql console? Marc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, Febr