Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: Re: [COMMIT...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 9263 of 10389
Post > Topic >>

Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 25, 2008 at 06:28 PM

"Tom Dunstan" <pgsql@[EMAIL PROTECTED]
> writes:
> On Sat, Apr 26, 2008 at 2:51 AM, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
>> Further, as already noted, if you do have to rewrite then a series of
>> manual ALTER COLUMN TYPE operations would probably be a *better* answer
>> than a monolithic implementation, because of the locking problems
>> involved in doing it in one transaction.

> I don't understand this if it's calling option 2 the monolithic
> implementation.

No, I was imagining an option-1 implementation trying to sup****t
rewriting of all affected tables in a single "monolithic" command.

			regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 3 Posts in Topic:
Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated
pgsql@[EMAIL PROTECTED]   2008-04-26 03:31:37 
Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated
tgl@[EMAIL PROTECTED] (T  2008-04-25 18:28:57 
Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated
Andreas.Zeugswetter@[EMAI  2008-04-28 10:54:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 6:19:37 CDT 2008.