Postgres Pro
Downloads
Home   >   mailing lists

Returning NEW in an on-delete trigger - Mailing list pgsql-general

From Michael Nolan
Subject Returning NEW in an on-delete trigger
Date
Msg-id 4abad0eb0809181121g625cb397qbd40ece12afecd7a@mail.gmail.com
Whole thread Raw
Responses Re: Returning NEW in an on-delete trigger  (Jeff Davis <pgsql@j-davis.com>)
Re: Returning NEW in an on-delete trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Running initdb while logged in as Administrator user (Windows)
Next
From: Jeff Davis
Date:
Subject: Re: Returning NEW in an on-delete trigger