Skip site navigation (1) Skip section navigation (2)

error tryiing to insert with collate

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: error tryiing to insert with collate
Date: 2012-01-02 15:06:26
Message-ID: 20120102160626.45b5372a@anubis.defcon1 (view raw or flat)
Thread:
Lists: 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".

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2012-01-02 15:22:19
Subject: Re: error tryiing to insert with collate
Previous:From: Craig BarnesDate: 2012-01-01 20:07:07
Subject: Re: ERROR: invalid input syntax for integer: SQL state: 22P02

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group