From: | Leif Jensen <leif(at)crysberg(dot)dk> |
---|---|
To: | Marc Schablewski <ms(at)clickware(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Update rule on a view - what am I doing wrong |
Date: | 2013-01-22 15:16:25 |
Message-ID: | 23124674.18768.1358867785175.JavaMail.root@quick |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Marc,
Thanks a lot. That works fine. The names 'NEW' and 'OLD' works fine.
Leif
----- "Marc Schablewski" <ms(at)clickware(dot)de> wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-01-22 15:34:23 | Re: Pg_xlog increase due to postgres crash (disk full) |
Previous Message | Cliff de Carteret | 2013-01-22 14:59:52 | Re: Pg_xlog increase due to postgres crash (disk full) |