Skip site navigation (1) Skip section navigation (2)

Re: RI triggers and schemas

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>,Jan Wieck <JanWieck(at)Yahoo(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: RI triggers and schemas
Date: 2002-03-27 03:50:41
Message-ID: 3CA14191.33DC31A9@tpf.co.jp (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Alastair D'SilvaDate: 2002-03-27 03:51:37
Subject: Re: initdb dies during IpcSemaphoreCreate under BSD jail
Previous:From: Alvaro HerreraDate: 2002-03-27 03:00:00
Subject: Re: Rolling v7.2.1 ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group