From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Barbour <dbarbour@istation.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Syntax on BEFORE Trigger - Cascade?
In-reply-to: <CAEMHB2S2GAaxS9Fsisw=7ebYB=7AMb5_4QuGFHX5G8ZXYC5KVw@mail.gmail.com>
References: <CAEMHB2S2GAaxS9Fsisw=7ebYB=7AMb5_4QuGFHX5G8ZXYC5KVw@mail.gmail.com>
Comments: In-reply-to David Barbour <dbarbour@istation.com>
	message dated "Thu, 13 Jun 2024 09:11:01 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1792891.1718288587.1@sss.pgh.pa.us>
Date: Thu, 13 Jun 2024 10:23:07 -0400
Message-ID: <1792892.1718288587@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1792892.1718288587%40sss.pgh.pa.us>
Precedence: bulk

David Barbour <dbarbour@istation.com> writes:
> The files are appropriately deleted in Oracle, but Postgres is returning
> the following:
> *ERROR: Attempt to suppress referential action with before trigger.
> CONTEXT: SQL statement "DELETE FROM ONLY "idev"."import_file" WHERE $1
> OPERATOR(pg_catalog.=) "import_job_oid"" *

I don't know what you're running there, but there is no such error
message in community Postgres.  Having said that, maybe what you
need is to *not* have any before trigger applied to the import_file
table.

			regards, tom lane