Re: Updating - Mailing list pgsql-general

From Daniel Verite
Subject Re: Updating
Date
Msg-id aa7c92bb-39dc-46f0-b7cd-fa07bf41738e@mm
Whole thread Raw
In response to Re: Updating  (Bob Pawley <rjpawley@shaw.ca>)
List 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

pgsql-general by date:

Previous
From: "Tyler, Mark"
Date:
Subject: Problem with async notifications of table updates
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: Problem with async notifications of table updates