BUG #4434: Error inserting into view - unrecognized node type: 313
От | Dean Rasheed |
---|---|
Тема | BUG #4434: Error inserting into view - unrecognized node type: 313 |
Дата | |
Msg-id | 200809231431.m8NEVEU5053058@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4434: Error inserting into view - unrecognized node type: 313
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4434 Logged by: Dean Rasheed Email address: dean_rasheed@hotmail.com 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.
В списке pgsql-bugs по дате отправления: