Search Postgresql Archives

Re: triggering on deletes, NEW row or OLD row?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Peter@xxxxxxxxxxxx
Subject: Re: triggering on deletes, NEW row or OLD row?
From: Richard Huxton <dev@xxxxxxxxxxxx>
Date: Tue, 13 Dec 2005 20:45:31 +0000
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <439F013D.10103@xxxxxxxxxxxx>
References: <439F013D.10103@xxxxxxxxxxxx>
User-agent: Thunderbird 1.5 (X11/20051025)

Peter L. Berghold wrote:

The question I have is with a trigger on delete are the NEW and OLD
system variables valid? Which one is valid?


OLD for deletes. NEW for inserts. Both for updates.

HTH
--
  Richard Huxton
  Archonet Ltd

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- triggering on deletes, NEW row or OLD row?
  - From: Peter L. Berghold

Prev by Date: Re: php + postgresql pg_connect problem
Next by Date: Re: "incomplete startup packet" on SGI
Previous by thread: Re: triggering on deletes, NEW row or OLD row?
Next by thread: php + postgresql pg_connect problem
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux