Hi,

Am Do, den 26.08.2004 schrieb Bjørn T Johansen um 9:48:
> Is it possible to alter field type (from varchar to text) without making 
> a new table?

In 8.0 I think. 
Common practice in 7.4.x is:

BEGIN work;
ALTER TABLE yourtable ADD COLUMN tempcolumn text;
UPDATE yourtable SET tempcolumn = origcolumn;
ALTER TABLE yourtable DROP COLUMN origcolumn;
ALTER TABLE yourtable RENAME tempcolumn TO origcolumn;
COMMIT work;

Since text and (unlimited) varchar are quite the same,
you could get away with modifying the system tables.
But I would not recomment to do so.

Regards
Tino Wildenhain

In response to

• Alter field type? at 2004-08-26 07:48:33 from Bjørn T Johansen

Responses

• Re: Alter field type? at 2004-08-26 09:49:09 from Bjørn T Johansen

pgsql-general by date

Next:	From: Greg Stark	Date: 2004-08-26 08:36:18
	Subject: Re: Alter field type?
Previous:	From: gnari	Date: 2004-08-26 08:27:59
	Subject: Re: Possible to insert quoted null value into integer field?