Postgres Pro
Downloads
Home   >   mailing lists

Re: Update rule on a view - what am I doing wrong - Mailing list pgsql-general

From Marc Schablewski
Subject Re: Update rule on a view - what am I doing wrong
Date
Msg-id 50FE9AC6.6060701@clickware.de
Whole thread Raw
In response to Re: Update rule on a view - what am I doing wrong  (Leif Jensen <leif@crysberg.dk>)
List pgsql-general
Tree view
Hi Leif,
  Am 22.01.2013 14:34, schrieb Leif Jensen:
CREATE update_rule_func( old record, new record ) AS ...  I am told, that I cannot use record for the parameter type. Could you please
You should use your view instead of 'record' as parameter type, i.e. CREATE update_rule_func( old V_YOUR_VIEW, new V_YOUR_VIEW ) AS ... . Also, I'm not sure if 'new' and 'old' are reserved keywords in PostgreSQL, so you might want to choose different names for your parameters if you still have trouble with that function.

Marc

pgsql-general by date:

Previous
From: Leif Jensen
Date:
Subject: Re: Update rule on a view - what am I doing wrong
Next
From: Dmitriy Igrishin
Date:
Subject: RAISE NOTICE ... and CONTEXT field of the error report.