Re: how do you get there from here? - Mailing list pgsql-general

From Tom Lane
Subject Re: how do you get there from here?
Date
Msg-id 17325.1240883089@sss.pgh.pa.us
Whole thread Raw
In response to Re: how do you get there from here?  ("Michael P. Soulier" <michael_soulier@mitel.com>)
Responses Re: how do you get there from here?
List pgsql-general
"Michael P. Soulier" <michael_soulier@mitel.com> writes:
> Tom Lane wrote:
>> *Why* you've got such triggers is not apparent from what you've told us.

> I've not explicitely created any triggers. The table has constraints,
> and if that results in triggers created by the system, then that would
> be why.

Yup...

> Foreign-key constraints:
>     "dashboard_tuginstance_node_id_fkey" FOREIGN KEY (node_id)
> REFERENCES nodes(id) DEFERRABLE INITIALLY DEFERRED

This is what's creating the limitation.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: triggers and execute...
Next
From: Ian Barwick
Date:
Subject: Re: Noob Q: Is the PG database its own source code backup?