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

[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