| From: | "Travis Hoyt" <thoyt(at)npc(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Rules and Views |
| Date: | 2001-10-09 13:24:26 |
| Message-ID: | 3BC2FA8A.DF7B0744@npc.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Can anyone give me a clue as to how to get rules working with views? I
have a large table I call 'sardata' and several views, an example of
which is 'sun_u'. What I want to do is insert data into 'sun_u' and
have it in turn actually update the 'sardata' table. I've looked at the
examples on the postgresql web page but when I try those examples it
complains, saying "Attribute 'usr' not found" with 'usr' being my first
column. Here is a copy of one of my attempts:
create rule ins_sun_u as on insert
sarweb-> to sun_u do instead insert into sardata values ( usr, sys, wio,
idle, time, systemid );
ERROR: Attribute 'usr' not found
Any help would be greatly appreciated.
Thanks,
Travis
| Attachment | Content-Type | Size |
|---|---|---|
| thoyt.vcf | text/x-vcard | 304 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-09 13:57:39 | Re: Rules and Views |
| Previous Message | Stoffel van Aswegen | 2001-10-09 09:30:55 | JDBC ResultSet |