On Mon, Jan 12, 2009 at 1:02 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: .....<snip>.... > regression=# update pg_attribute set atttypmod = 35+4 where attrelid = 't1'::regclass and attname = 'f1'; > UPDATE 1 > regression=# \d t1 > Table "public.t1" > Column | Type | Modifiers > --------+-----------------------+----------- > f1 | character varying(35) | > > (Why the +4 you ask? It's historical :-() > Tom, this has worked, and a "\d TABLENAME" shows that the column is varchar(35). But I still have messages in my log saying: --- ERROR: value too long for type character varying(20) --- Why is this? There are no other varchar(20) columns in my DB at all, no other table. Only this column used to be 20 characters and using your command I changed it to 35. It looks alright, the column also accepts the value, but the error is logged. I'm confused. How to stop the error? Thanks -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
