[BUGS] rules ON INSERT

2004-11-07 Thread Ralph Heinkel
Hi, thanks to everybody who has answered to my question. Indeed the documents let the programmer hope that s/he gets what should be expected: In postgresql-7.4.1/doc/html/rules-update.html it says: For ON INSERT rules, the original query (if not suppressed by INSTEAD) is done before any

[BUGS] possible bug using combination of 'serial' and rule

2004-10-31 Thread Ralph Heinkel
Hi, I think this is a bug (I hope not a feature). Description: The table 'tmp' gets records added, and uses a serial to fill the attribute 'strorage_id'. The table has a rule which logs all inserts into the table 'log'. Problem: For each insert into tab