Re: Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "Matteo Beccati" <php(at)beccati(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite
Date: 2009-03-05 19:55:59
Message-ID: 49AFD9EE.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

>>> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> wrote:
> the table will be scanned but not rewritten

That can still be a very long time on some tables.

And there would still be the issue of dodging all the brickbats thrown
at me by developers whose tools use the system tables to limit the
number of characters a user is allowed to type into an application.

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Xuân Baldauf 2009-03-05 20:27:34 Re: Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite
Previous Message Jaime Casanova 2009-03-05 19:49:48 Re: Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite

Browse pgsql-hackers by date

  From Date Subject
Next Message Dickson S. Guedes 2009-03-05 19:56:40 Re: cbrt() broken in AIX
Previous Message Tom Lane 2009-03-05 19:50:24 Re: SIGHUP during recovery