David Barbour <dbarbour(at)istation(dot)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