Statement trigger on delete object OID

From: Laurent Rahuel <laurent(dot)rahuel(at)net-ng(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Statement trigger on delete object OID
Date: 2009-04-01 14:38:10
Message-ID: 49D37C52.8010500@net-ng.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is there any way to get some attributes values of the first object
involved in a delete on cascade group inside a trigger definition?
I wish I could fire a trigger after a delete on cascade has been done
but I need some informations which are linked to the first element deleted.

Using a trigger on each row could give access to the OLD object but
firing a trigger on a cascade relation may be a performance killer.

Any clue ?

Regards,

Laurent

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-04-01 14:38:50 Re: [GENERAL] string_to_array with empty input
Previous Message CM J 2009-04-01 14:15:26 Re: Postgres: Packaging & Server Startup