Re: [BUGS] Problem with a sequence being acted on by an on insert rule.

2002-11-07 Thread Tom Lane
Mark Le Huray <[EMAIL PROTECTED]> writes: > - create sequence autonumber increment 1 minvalue 0 start 0; > - create table testtable1 ( pk int primary key ); > - create table testtable2 ( fk int primary key references > testtable1(pk)); > - create rule updatetesttable2 as on insert to testtable1 do

Re: [BUGS] Problem with a sequence being acted on by an on insert

2002-11-07 Thread Stephan Szabo
On 5 Nov 2002, Mark Le Huray wrote: > Apologies if this bug has already been reported and I am also reasonably > new to postgresql so I might be doing something stupid :-) > > Anyway to replicate the problem: > > Initial tables: > > - create sequence autonumber increment 1 minvalue 0 start 0; > -