[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 (

[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? Im not real familiar with rules, but it seems

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:

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 column