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

2009-03-05 Thread Matteo Beccati
Guillaume Smet ha scritto: On Wed, Mar 4, 2009 at 11:50 AM, Peter Eisentraut pete...@gmx.net wrote: The question is how you want to implement this in a data type independent fashion. You can't assume that increasing the typmod is a noop for all data types. Sure. See my previous answer on

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

2009-03-05 Thread Jaime Casanova
On Thu, Mar 5, 2009 at 10:47 AM, Matteo Beccati p...@beccati.com wrote: Guillaume Smet ha scritto: On Wed, Mar 4, 2009 at 11:50 AM, Peter Eisentraut pete...@gmx.net wrote: The question is how you want to implement this in a data type independent fashion.  You can't assume that increasing the

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

2009-03-05 Thread Jaime Casanova
On Thu, Mar 5, 2009 at 3:27 PM, Xuân Baldauf xuan--2009.03--submitbug--support--postgresql@baldauf.org wrote: Well, while this behaviour is well-known for PostgreSQL, this is actually an abuse of syntax. If there are legitimate requirements for rewriting a table, then there should be