On tis, 2011-09-20 at 00:32 -0400, Tom Lane wrote:
> =?Big5?B?pHCoqA==?= writes:
> > 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
>
> I hope that's not the exact p
=?Big5?B?pHCoqA==?= writes:
> 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
I hope that's not the exact phrasing of the error message ... but
what it's probably trying
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
> "yulin liu" writes:
> > can't change Column COLLATE pg_catalog."default" to
> pg_catalog."zh_TW.euctw"
"yulin liu" 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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscri
The following bug has been logged online:
Bug reference: 6214
Logged by: yulin liu
Email address: e9320...@gmail.com
PostgreSQL version: PostgreSQL 9.1
Operating system: CentOS release 5.4
Description:can't change Column COLLATE
Details:
can't change Column COLLATE