Re: RI triggers and schemas - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: RI triggers and schemas
Date
Msg-id 3CA14191.33DC31A9@tpf.co.jp
Whole thread Raw
In response to RI triggers and schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: RI triggers and schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> As of CVS tip, referential integrity triggers are kinda broken: they
> will only work for tablenames that are in the current search path.
> I think that instead of storing just table names in the trigger
> parameters, we should store either table OIDs or schema name + table
> name.  Do you have any preferences about this?
> 
> An advantage of using OIDs is that we could forget the pushups that
> ALTER TABLE RENAME presently goes through to update RI triggers.

I'm always suspicious about the spec if it makes RENAME easy.

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Rolling v7.2.1 ...
Next
From: "Alastair D'Silva"
Date:
Subject: Re: initdb dies during IpcSemaphoreCreate under BSD jail