The following bug has been logged online: Bug reference: 4434 Logged by: Dean Rasheed Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: SuSE 10.3 64-bit Description: Error inserting into view - unrecognized node type: 313 Details:
I'm getting an error when trying to insert into a view, using a rule. As far as I can work out, it only errors if my insert statement tries to insert multiple rows, and any of the rows contains a sub-query. Here is a simple made-up example: DROP TABLE IF EXISTS foo CASCADE; CREATE TABLE foo(a int, b int); CREATE VIEW foo_v AS SELECT * FROM foo; CREATE RULE foo_r AS ON INSERT TO foo_v DO INSTEAD INSERT INTO foo VALUES(NEW.a, NEW.b); INSERT INTO foo_v VALUES ((SELECT 1), (SELECT 2)), ((SELECT 3), (SELECT 4)); ERROR: unrecognized node type: 313 Inserting the rows one at a time works OK, as does inserting into a table, or inserting both rows together but without using sub-queries. I've tested this with 8.3 and a fairly recent CVS version. Dean. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs