Re: how do you get there from here?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael P(dot) Soulier" <michael_soulier(at)mitel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how do you get there from here?
Date: 2009-04-28 01:44:49
Message-ID: 17325.1240883089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Michael P. Soulier" <michael_soulier(at)mitel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2009-04-28 05:23:54 Re: Noob Q: Is the PG database its own source code backup?
Previous Message Scott Marlowe 2009-04-27 21:37:22 Re: triggers and execute...