Re: [BUGS] Double sequence increase on single insert with RULE on

2005-11-18 Thread Sarunas Krisciukaitis
16, 2005 at 10:31:10AM +0200, Sarunas Krisciukaitis wrote: I understand that RULES are like macros. Strangest thing here is that INSERT to test1 will touch only one sequence: test1_id_seq. And it increments test1_id_seq twice during insert with RULE. Yes, that's a well-known effe

Re: [BUGS] Double sequence increase on single insert with RULE on

2005-11-16 Thread Sarunas Krisciukaitis
I understand that RULES are like macros. Strangest thing here is that INSERT to test1 will touch only one sequence: test1_id_seq. And it increments test1_id_seq twice during insert with RULE. Then all sequence procedures like lastval() and currval() will return number (as stated in report), wh

[BUGS] Double sequence increase on single insert with RULE on targeted table

2005-11-15 Thread Sarunas Krisciukaitis
Dear All, A program produces the wrong output for any given input. Here comes bug report: 1. Database dump is attached. 2. Input: "BEGIN; INSERT INTO test1(some_text) VALUES ('test1'); SELECT lastval() as id; END;" 3. Output: INSERT 0 1 id 3 (1 row) 4. Exspected Output: id 2 (1 row)