Re: Changing column types... - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Changing column types...
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEPPCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Changing column types...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Changing column types...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 4. Is there any worth in me submitting a patch that will allow
> rudimentary
> > column type changing, so long as the types are binary compatible???
>
> Hmm.  Seems like that case, and the various ones involving adjustment of
> char/varchar length by hacking atttypmod, would be useful to support via
> ALTER COLUMN even if we don't have a full implementation.  Essentially
> this would be taking the existing folklore about safe ways to hack
> pg_attribute and reducing them to code --- why not do it?

Can you only reduce the length of a varchar (say) or can you actually
increase them as well?

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Changing column types...
Next
From: Bruce Momjian
Date:
Subject: Re: timeout implementation issues