From: | "w fm3" <wfm3(at)hotmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Update rule on view with multiple tables fails? |
Date: | 2003-10-25 18:39:52 |
Message-ID: | BAY1-F132LbcfmINlCn00009b32@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi
Could anyone let me know if I have done something wrong with the rule?
As when trying to update via ODBC the update fails. - But seems to work with
php though?
--
Postgresql 7.3.2
odbc up to and incl ver7.03.0201
1 view, joining 2 tables
(1 - many in this case- companies and contacts- 'orgref' and 'conref' being
the Primary keys)
--
View definition looks like:
SELECT contacts.conref, contacts.orgref, contacts.lastname,
organisations.lob
FROM (contacts
LEFT JOIN organisations ON ((contacts.orgref = organisations.orgref )));
Rule looks like:
UPDATE contacts SET lastname = new.lastname
WHERE (old.conref = contacts.conref ); UPDATE organisations SET lob =
new.lob
WHERE (old.orgref = organisations.orgref ); );
---
in this case trying to make changes to the lastname and lob fields.
Many thanks
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Lang | 2003-10-27 15:04:18 | Driver configuration: Manage (DSN) |
Previous Message | Walt H | 2003-10-24 14:11:40 | Re: Error in convert.c when compiling w/ odbcver=0x0300 |