Search Postgresql Archives

Re: Syntax on BEFORE Trigger - Cascade?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



David Barbour <dbarbour@xxxxxxxxxxxx> 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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux