Re: [BUGS] BUG #5400: Columns count mismatch in RULE with subquery

2010-03-31 Thread Tom Lane
"Teodor Buchner" writes: > CREATE OR REPLACE RULE move_iteration_1 AS ON INSERT TO a.iteration DO ALSO > INSERT INTO b.iteration(id,date_period_begin) > SELECT (NEW.id,NEW.date_period_begin) FROM a.iteration; Your use of parentheses in the SELECT targetlist is incorrect (and would be with o

[BUGS] BUG #5400: Columns count mismatch in RULE with subquery

2010-03-31 Thread Teodor Buchner
The following bug has been logged online: Bug reference: 5400 Logged by: Teodor Buchner Email address: t.buch...@autoguard.pl PostgreSQL version: 8.4.1 Operating system: Linux Description:Columns count mismatch in RULE with subquery Details: When SELECT INSERT synta