Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: ALTER TABLE TODO items
Date
Msg-id 200405060300.i4630Tq11932@candle.pha.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ALTER TABLE TODO items  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
> > Does that mean I'll want to disable triggers while I do this?
> 
> Hrm.  Right now the code does not fire triggers at all, but that seems
> wrong.  However, I doubt that very many triggers could cope with update
> events in which the old and new rows have different rowtypes :-(.
> Any thoughts what to do about that?

If triggers exist, I think we should just throw a warning that triggers
will not be fired.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Multiple Xids in PGPROC?
Next
From: sdv mailer
Date:
Subject: Re: PostgreSQL pre-fork speedup