Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Jonah H. Harris
On 10/26/06, Gregory Stark <[EMAIL PROTECTED]> wrote: I think what you want is to add a new method entry in pg_type to allow a type to declare a method to tell you whether a change is work-free or not. Then any type, even user-defined types, can allow some changes to be work-free and some not wit

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Gregory Stark
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 10/26/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> This makes some really quite unacceptable assumptions about >> the meaning and encoding of typmod ... > > True, so VARCHAR seems like the only one? That's the only one I've > really encountered in

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 10/26/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> This makes some really quite unacceptable assumptions about >> the meaning and encoding of typmod ... > True, so VARCHAR seems like the only one? That's the only one I've > really encountered in th

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Jonah H. Harris
On 10/26/06, Tom Lane <[EMAIL PROTECTED]> wrote: This makes some really quite unacceptable assumptions about the meaning and encoding of typmod ... True, so VARCHAR seems like the only one? That's the only one I've really encountered in the field on a fairly regular basis. I'm also wondering

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > The attached patch handles the simple case where a user wants to > increase the user-defined storage size of a variable length object, > such as VARCHAR or NUMERIC, without having to rebuild the table. This makes some really quite unacceptable assump