error tryiing to insert with collate - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject error tryiing to insert with collate
Date
Msg-id 20120102160626.45b5372a@anubis.defcon1
Whole thread Raw
Responses Re: error tryiing to insert with collate  (Thom Brown <thom@linux.com>)
Re: error tryiing to insert with collate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi list,

Original collation srv+clis = fr_FR.utf8

I'm trying to insert as:
INSERT INTO tst1m VALUES ( default,
    'źŠÿǚŦÍÏÔJŽććżûŘäpèăîÍŢŃDµŴŻĊĜÿG' COLLATE "hu_HU.utf8",
    'úĽčŏṻŗĿÁťħĵŇğŚáÛĨæħŽīhĴÝUĶďeźİīŇč' COLLATE "hu_HU.utf8" );

and get: ERROR:  unsupported node type: 325

hu_HU.utf8 is installed - so is this operation impossible
and collate only reserved to select statements?

JY
--
Everything can be filed under "miscellaneous".

pgsql-novice by date:

Previous
From: Craig Barnes
Date:
Subject: Re: ERROR: invalid input syntax for integer: SQL state: 22P02
Next
From: Thom Brown
Date:
Subject: Re: error tryiing to insert with collate