Search Postgresql Archives

Returning NEW in an on-delete trigger

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

To: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Subject: Returning NEW in an on-delete trigger
From: "Michael Nolan" <htfoot@xxxxxxxxx>
Date: Thu, 18 Sep 2008 14:21:20 -0400

Recently I discovered a coding error of mine in a trigger that is called only for deletes.

I was returning NEW instead of OLD.

Since NEW is undefined when deleting a row, it was failing and the row wasn't being deleted.

However, it was failing silently. Shouldn't this have recorded an error or warning somewhere?
--
Mike Nolan

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

Follow-Ups:
- Re: Returning NEW in an on-delete trigger
  - From: Tom Lane
- Re: Returning NEW in an on-delete trigger
  - From: Jeff Davis

Prev by Date: Re: Running initdb while logged in as Administrator user (Windows)
Next by Date: Re: Returning NEW in an on-delete trigger
Previous by thread: Pg COnference: Call for Lightning Talks
Next by thread: Re: Returning NEW in an on-delete trigger
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