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

Re: [GENERAL] Altering a table with a rowtype column

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>, Pg General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Altering a table with a rowtype column
Date: 2012-03-07 20:49:22
Message-ID: 1331153306-sup-5909@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Excerpts from Tom Lane's message of mié mar 07 17:31:32 -0300 2012:

> This probably could be done for rowtype columns as well, but nobody has
> collected the necessary round tuits.  I think there was some fear of
> locking/deadlock issues, too.

It's probably easy to do if you require it to be marked INVALID
initially and then validate the tables using it one by one.

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Merlin MoncureDate: 2012-03-07 20:49:39
Subject: Re: [GENERAL] Altering a table with a rowtype column
Previous:From: Tom LaneDate: 2012-03-07 20:31:32
Subject: Re: [GENERAL] Altering a table with a rowtype column

pgsql-general by date

Next:From: Merlin MoncureDate: 2012-03-07 20:49:39
Subject: Re: [GENERAL] Altering a table with a rowtype column
Previous:From: Tom LaneDate: 2012-03-07 20:31:32
Subject: Re: [GENERAL] Altering a table with a rowtype column

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