Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6214: can't change Column COLLATE - Mailing list pgsql-bugs

From 小豕
Subject Re: BUG #6214: can't change Column COLLATE
Date
Msg-id CAD7ESE3JhFdMDUtK_nG8oq7Mr_e0c7BYJd+utfwVfMvhhipX_Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6214: can't change Column COLLATE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #6214: can't change Column COLLATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Use   ALTER TABLE item  ALTER COLUMN title TYPE character varying(2000) COLLATE pg_catalog."zh_TW.euctw";
but, SQL state: 42704  "UTF8" "pg_catalog.zh_TW.euctw" not found

2011/9/19 Tom Lane <tgl@sss.pgh.pa.us>
"yulin liu" <e9320.tw@gmail.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6214: can't change Column COLLATE
Next
From: Tom Lane
Date:
Subject: Re: BUG #6214: can't change Column COLLATE