Re: BUG #6214: can't change Column COLLATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "yulin liu" <e9320(dot)tw(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6214: can't change Column COLLATE
Date: 2011-09-19 15:58:29
Message-ID: 18103.1316447909@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"yulin liu" <e9320(dot)tw(at)gmail(dot)com> writes:
> can't change Column COLLATE pg_catalog."default" to pg_catalog."zh_TW.euctw"

Use ALTER TABLE ... ALTER COLUMN ... TYPE ... COLLATE ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 小豕 2011-09-20 01:29:08 Re: BUG #6214: can't change Column COLLATE
Previous Message yulin liu 2011-09-19 06:47:28 BUG #6214: can't change Column COLLATE