Re: Triggers on system tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Triggers on system tables
Date: 2004-04-20 14:03:28
Message-ID: 200404201403.i3KE3S013686@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to TODO:

* Allow AFTER triggers on system tables

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

Gavin Sherry wrote:
> On Thu, 12 Feb 2004, Tom Lane wrote:
>
> > Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> > > Do you have an example at hand of a system function which will face this
> > > problem so that I can see what is involved?
> >
> > Mmm ... try CREATE TABLE with foreign keys. IIRC the basic table is
> > created and then we do ALTER TABLE ADD FOREIGN KEY.
>
> Ahh, of course. I misunderstood you. I was taking system 'function'
> literally. CREATE TABLE by itself is bad enough. We do ALTER TABLE ADD
> TOAST outside of DefineRelation().
>
> Gavin
>
> ---------------------------(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) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-20 14:03:51 Re: COPY CSV keywords
Previous Message Andrew Dunstan 2004-04-20 13:57:10 Re: pg_encoding not needed anymore