Re: Changing column types...

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing column types...
Date: 2002-04-05 03:10:07
Message-ID: GNELIHDDFBOCMGBFGEFOKEPPCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-04-05 03:22:57 Re: timeout implementation issues
Previous Message Christopher Kings-Lynne 2002-04-05 03:08:36 Re: Changing column types...