[SQL] View with Union and update rule - fails

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

[SQL] simulating row ownership

I have a table where I want everyone to be able to be able to insert and select. But they should only be able to update and delete rows that they “own”.  The table has a column indicating the owner.   What is the best way to accomplish this?  I’m not real familiar with rules, but it see

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

=?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

Re: [SQL] simulating row ownership

On Fri, Jan 07, 2005 at 11:52:07AM -0500, Rick Schumeyer wrote: > I have a table where I want everyone to be able to be able to insert and > select. > > But they should only be able to update and delete rows that they "own". The > table has a column indicating the owner. What does the owner col