RE: [GENERAL] Alter column length

2001-03-23 Thread Tamsin
I've used that method without any problems. I had to experiment a bit by creating test tables with different length columns to see what to set atttypmod to, because I didn't really know what the value meant! Seemed to work ok though... Tamsin > > - > update pg_attrib

Re: [GENERAL] Alter column length

2001-03-23 Thread Tom Lane
"Dan Wilson" <[EMAIL PROTECTED]> writes: > I want to alter the length of a column without dumping an re-creating the > table. What kind of column? Offhand I think that hacking atttypmod would be safe for varchar(n) but not char(n). BTW, you might need to start a new backend session to see the e