Re: [BUGS] Bug #485: strange behavior when creting rules with serial id

2001-10-17 Thread Tom Lane
[EMAIL PROTECTED] writes: > CREATE RULE insert_test2 AS ON INSERT TO test1 DO INSERT INTO test2 > (sum1, name2, id, id1) VALUES (new.sum, new.name, new.id, > nextval('"test2_id1_seq"'::text)); "NEW" is a macro, not a variable. This rule will be expanded to something like INSERT INTO test2 (sum1

Re: [BUGS] Bug #485: strange behavior when creting rules with

2001-10-17 Thread Stephan Szabo
On Wed, 17 Oct 2001 [EMAIL PROTECTED] wrote: > Tony Tomov ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > strange behavior when creting rules with serial id > > Long Description > I do not know if this is a bug, but f

[BUGS] Bug #485: strange behavior when creting rules with serial id

2001-10-16 Thread pgsql-bugs
Tony Tomov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description strange behavior when creting rules with serial id Long Description I do not know if this is a bug, but for me this is a strange behavior. I will describe the followin