Re: Unusual problem. A sequence is incrementing by 2 when

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unusual problem. A sequence is incrementing by 2 when
Date: 2001-11-05 04:16:50
Message-ID: 20011104201048.C38619-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I think this is probably the same side effect that causes
insert rules using NEW.<nextvalcol> to increment and put
different values in a master and detail table. IIRC,
when it sees the new.idnum in your rule anywhere it sees
the nextval(...) not the value and will call nextval again.
I think if you search for foreign key problems and
insert rules you'll probably find posts by Tom that
probably have more details.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-11-05 04:22:10 My new job with SRA
Previous Message Bruce Momjian 2001-11-05 04:04:27 My new job