openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Bauer <techhu...@gmail.com>
Subject Re: relation "mySequence" already exists
Date Wed, 09 Jun 2010 13:38:48 GMT
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 <jerry@jerrycarter.org> 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]" <
> ml-node+5156733-944799821-93721@n2.nabble.com<ml-node%2B5156733-944799821-93721@n2.nabble.com>
>  > 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
> ml-node+208411-1595610943-93721@n2.nabble.com<ml-node%2B208411-1595610943-93721@n2.nabble.com>
> > 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message