Re: [SQL] View with Union and update rule - fails

2005-01-07 Thread Tom Lane
=?ISO-8859-2?Q?Filip_Jirs=E1k?= <[EMAIL PROTECTED]> writes: > I have trouble with following VIEW and RULE: > ... > I get: > ERROR: unrecognized node type: 651 I can replicate this failure in 7.4.6 but not in 8.0. I believe it's fixed by the change discussed here: http://archives.postgresql.org/p

[SQL] View with Union and update rule - fails

2005-01-07 Thread Filip Jirsák
Hi, I have trouble with following VIEW and RULE: CREATE SCHEMA test AUTHORIZATION postgres; CREATE TABLE test.table1 ( uid int4, col1 int4, col2 int4, col3 int4 ); CREATE TABLE test.table2 ( col4 int4 ) INHERITS (test.table1); CREATE TABLE test.table3 ( c