Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting char to varchar automatically - Mailing list pgsql-general

From Tom Lane
Subject Re: Converting char to varchar automatically
Date
Msg-id 27400.1412637416@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting char to varchar automatically  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Converting char to varchar automatically  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view 
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> Just a heads-up: each of those ALTER's will rewrite the table, so unless your database is tiny this will be a slow
process.There's ways to work around that, but they're significantly more complicated. 

I think he's trying to get rid of all the blank-padding he's got right
now, so table rewrites are unavoidable.

            regards, tom lane

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: table versioning approach (not auditing)
Next
From: Tom Lane
Date:
Subject: Re: Converting char to varchar automatically