Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger problem 2 - Mailing list pgsql-general

From Richard Huxton
Subject Re: Trigger problem 2
Date
Msg-id 41AD8A96.2000805@archonet.com
Whole thread Raw
In response to Trigger problem 2  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
Tree view 
Jamie Deppeler wrote:
>
>     UPDATE wip.resource
>     set "name" = datarecord.borname
>     where wip.resource."primary" = OLD."primary";
>
>
> get the following error
>
> Error: record "old" is not yet assigned

If called from an INSERT then OLD is undefined, since there is no old
version of the row.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Najib Abi Fadel"
Date:
Subject: Re: granting privileges
Next
From: Chris Green
Date:
Subject: Re: [HACKERS] Adding Reply-To: to Lists configuration ...