Trigger: what rows were deleted?

From: Ciprian Popovici <ciprian(at)zuavra(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger: what rows were deleted?
Date: 2004-12-17 13:53:48
Message-ID: 1103291628.41c2e4ec382b1@imp.online.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to make a trigger, fired by DELETE. The associated function
needs to know what rows were deleted in order to perform a DELETE in
another table as well. (Foreign keys are not acceptable.) I don't seem
to be able to find this kind of info being passed to the function. The
special vars don't seem to have something useful. The arguments to the
trigger could help, but can they be made dynamical? Is there any way
of identifying the affected rows?

--
Ciprian Popovici

Browse pgsql-general by date

  From Date Subject
Next Message Ciprian Popovici 2004-12-17 14:00:25 Re: Trigger: what rows were deleted?
Previous Message Florian G. Pflug 2004-12-17 13:20:36 analyze-error: "cannot compare arrays of different element types" revisited