| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
| Cc: | "Adrian Klaver" <aklaver(at)comcast(dot)net>,pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Updating |
| Date: | 2008-03-17 21:42:50 |
| Message-ID: | aa7c92bb-39dc-46f0-b7cd-fa07bf41738e@mm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bob Pawley wrote:
> I am attempting to use the following code but I get -
> "ERROR: NEW used in query that is not in a rule".
>
> This implies that I create a rule for NEW and OLD (which I haven't
needed
> before).
No, but are you sure you're using these keywords in the context of a
plpgsql function?
Can you post the entire CREATE statement that fails?
> BTW I noticed that Adrian used != . Is this symbol the same as <> ?
Yes it's the same.
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Gonzalez | 2008-03-17 22:39:09 | Re: Problem with async notifications of table updates |
| Previous Message | Tyler, Mark | 2008-03-17 20:55:29 | Problem with async notifications of table updates |