Re: Small FK patch to deal with tables without oids

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Small FK patch to deal with tables without oids
Date: 2001-11-12 05:32:26
Message-ID: 200111120532.fAC5WQ420143@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Tom, I assume you want this applied?

---------------------------------------------------------------------------

> Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> > Tables without oids wouldn't be able to be
> > used inside fk constraints, since some of the checks
> > in the trigger did a SELECT oid. Since the oid wasn't
> > actually used, I changed this to SELECT 1.
>
> Can't believe I missed that while looking for OID dependencies :-(
> Good catch!
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-12 05:39:05 Re: Possible major bug in PlPython (plus some other ideas)
Previous Message Bruce Momjian 2001-11-12 05:08:40 Re: PL/pgSQL RENAME bug?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-11-12 06:00:11 Re: Small FK patch to deal with tables without oids
Previous Message Tom Lane 2001-11-12 04:05:48 Re: Triggered Data Change check