Re: [HACKERS] ALTER TABLE MODIFY COLUMN

2001-04-13 Thread Mark Butler
Tom Lane wrote: > > Mark Butler <[EMAIL PROTECTED]> writes: > > Surely if we have an write exclusive table lock we can rewrite tuples > > in place rather than creating new versions with its corresponding 2x > > space requirement. > > Nyet. Consider transaction rollback. Well, the first thing t

Re: [HACKERS] ALTER TABLE MODIFY COLUMN

2001-04-12 Thread Tom Lane
Mark Butler <[EMAIL PROTECTED]> writes: > Surely if we have an write exclusive table lock we can rewrite tuples > in place rather than creating new versions with its corresponding 2x > space requirement. Nyet. Consider transaction rollback. regards, tom lane ---

Re: [HACKERS] ALTER TABLE MODIFY COLUMN

2001-04-12 Thread Hiroshi Inoue
Mark Butler wrote: > > I was looking at how hard it would be to support altering column types and it > seems to me that it would be trivial to support changing nullability, Yes. The problem is how to formulate 'DROP CONSTRAINT' feature. > increasing the maximum length of the VARCHAR data type a