Jodi- Here's an example of the "hack" approach, which I've used without causing any problems for some time:
update pg_attribute set atttypmod = 104 where attrelid = ( select oid from pg_class where relname = 'actor' and attname = 'actor_full_name' ); In your case, you'd substitute 254 for 104, your table name for "actor" and your field name for "actor_full_name"; -Nick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jodi Kanter Sent: Tuesday, August 19, 2003 1:34 PM To: Postgres Admin List Subject: [ADMIN] changing field length I am running 7.3.3. Can I change a field that is varying character(128) to varying character(250)? Thanks Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED] <!--[if !supportLineBreakNewLine]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]--> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
