Re: [GENERAL] Converting varchar() to text

2004-09-17 Thread Steve Atkins
On Fri, Sep 17, 2004 at 10:56:36AM -0400, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > On Wednesday 15 September 2004 12:29, Steve Atkins wrote: > >> Is there a safe way to convert varchar(n) to text, other than create > >> a new column, update, delete column, rename? > > > I wou

Re: [GENERAL] Converting varchar() to text

2004-09-17 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > On Wednesday 15 September 2004 12:29, Steve Atkins wrote: >> Is there a safe way to convert varchar(n) to text, other than create >> a new column, update, delete column, rename? > I wouldn't say it's impossible to do it, but several people have reported

Re: [GENERAL] Converting varchar() to text

2004-09-16 Thread Robert Treat
On Wednesday 15 September 2004 12:29, Steve Atkins wrote: > Is there a safe way to convert varchar(n) to text, other than create > a new column, update, delete column, rename? > > I have a number of databases that were built with varvhar(n) and which > should have been done with text. They're in pr