Forum OpenACS Q&A: Re: Increase column size

Collapse
5: Re: Increase column size (response to 1)
Posted by chandra shekher gupta on 09/19/06 10:42 AM
Hi Folks,

I say many-many thnaks to you people.
i have also one database on production and i am using postgres 8.1. I have to increase Option2 column size.This has helped me a lot ...Thanks a lot again.

update pg_attribute set atttypmod = 1000
where attrelid = ( select oid from pg_class where relname = 'questionaire_instance' )
and attname = 'option2';

Regards
Chandra shekher gupta
Infoaxon Technology UK limited.