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

From Richard Huxton
Subject Re: ALTER TABLE TODO items
Date
Msg-id 40994463.1020401@archonet.com
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
>>Wow, you can reference different column as part of the alter column.
> 
> 
> Yeah, the USING is actually any arbitrary expression over the old table
> row.  (Getting that to work was a tad tricky...)  So you can view this
> as a full-table UPDATE operation that folds in possible column type changes.

Does that mean I'll want to disable triggers while I do this? Actually, 
if the structure's changing I presume I'll want to drop/recreate my 
triggers anyway (even if they get reparsed like view definitions).

--   Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Multiple Xids in PGPROC?
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE TODO items