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

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

2002-11-07 Thread Mark Le Huray
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; - create table testtable1 ( pk int primary key ); - cr