Postgres Pro
Downloads
Home   >   mailing lists

alter table alter column to resize a varchar - Mailing list pgsql-admin

From Gary Stainburn
Subject alter table alter column to resize a varchar
Date
Msg-id 201209271023.57710.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: alter table alter column to resize a varchar  (Craig James <cjames@emolecules.com>)
List pgsql-admin
Tree view 
Hi folks.

I'm planning on extending a field in one of my main tables using:

alter table stock alter column type varchar(255);

to extend it from the current varchar(80).  My concern is that this table and
this field is used in a number of views, and views of views.

Are then any gotchas that I need to worry about or things I need to check, or
will it just work?

Gary
--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Debian Squeeze - no xml support for Pg 9.2
Next
From: Craig James
Date:
Subject: Re: alter table alter column to resize a varchar