I agree. Fixing this would be a good thing, provided it can be fixed without causing other issues (ie. removing or attempting to remove other system created sequences). I created OPENJPA-1689[1] for this issue.
-Jeremy [1] https://issues.apache.org/jira/browse/OPENJPA-1689 On Wed, Jun 9, 2010 at 5:50 AM, No1UNo <[email protected]> wrote: > > It would be nice to fix this. I'd hate to see anyone else hit this. > Failing that documenting this unexpected behavior would be okay. > > -=- Jerry (via iPhone) > > On Jun 9, 2010, at 12:38 AM, "Christopher Schmidt-4 [via OpenJPA]" < > [email protected]<ml-node%[email protected]> > > wrote: > > > Jersey, > > > > You are right. I changed the sequenceName to xxx and it works... > > > > Thx for help :) > > > > Am 08.06.2010 23:17 schrieb "Jeremy Bauer" <[hidden email]>: > > > > Hi Christopher, > > > > As it turns out, I don't think this problem is the same as > > OPENJPA-1259. > > There is special code in the PostgresDictionary that treats sequences > > suffixed with "_SEQ" as system managed sequences. The comment in > > PostgresDictionary.isSystemSequence reads: > > > > // filter out generated sequences used for bigserial cols, > > which are > > // of the form <table>_<col>_seq > > > > This explains why the same code worked for me on DB2. Are you able to > > modify the sequence name? (ex. sequenceName = "seq_obj_item_id") > > If not, > > please file a new JIRA. It may/should be possible to make the code > > a bit > > smarter by actually verifying _seq suffixed sequences are for a > > bigserial > > column[1] instead of just making the assumption. > > > > -Jeremy > > > > [1] > > > http://www.postgresql.org/docs/8.4/static/datatype-numeric.html#DATATYPE-SERIAL > > > > > > On Mon, Jun 7, 2010 at 2:39 PM, Jeremy Bauer <[hidden email]> wrote: > > > > > Christopher, > > > > > > I am ... > > > > > > View message @ > http://openjpa.208410.n2.nabble.com/relation-mySequence-already-exists-tp5136569p5156733.html > > To start a new topic under OpenJPA Users, email > [email protected]<ml-node%[email protected]> > > To unsubscribe from OpenJPA Users, click here. > > > > -- > View this message in context: > http://openjpa.208410.n2.nabble.com/relation-mySequence-already-exists-tp5136569p5157786.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. >
