Re: RI triggers and schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Jan Wieck <janwieck(at)yahoo(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: RI triggers and schemas
Date: 2002-04-01 18:32:32
Message-ID: 5804.1017685952@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I said:
> The table OIDs in pg_trigger would do fine if the trigger function could
> get at them, but it can't; so we need to copy them into the trigger
> arguments. (Hmm, I suppose another option is to extend the Trigger
> data structure to include tgconstrrelid, and just ignore the table names
> in the trigger argument list.)

After further thought, this is clearly the right approach to take,
because it provides a solution path for other triggers besides the RI
ones. So we'll fix the problem at the code level. The trigger
arguments will be unchanged, but the table names therein will become
purely decorative (or documentation, if you prefer ;-)). Perhaps
someday we could eliminate them ... but not as long as pg_dump dumps
RI constraints in the form of trigger definitions.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nic Ferrier 2002-04-01 19:46:55 Re: NOT IN queries
Previous Message Bruce Momjian 2002-04-01 18:18:39 Re: timeout implementation issues