Re: error tryiing to insert with collate

On Mon, 2 Jan 2012 15:22:19 +0000
Thom Brown  wrote:

Oops, strange: often my answer goes to ML goes only to sender;
back in the loop.

> 
> I suspect you have char or varchar fields you're inserting those text
> values into that are smaller than the values you're attempting to
> insert into them.  

Wrong hunch:
INSERT INTO tst1m VALUES (default, 
	'źŠÿǚŦÏÔćÍĊĜÿG' COLLATE "hu_HU.utf8", 
	'úĽčŏUĶďeźİīŇč' COLLATE "hu_HU.utf8" );
ERROR:  unsupported node type: 325

Anyway the columns are large enough to cope with these strings (32 & 64) 
as they are copy from an existing row.

>  In any case, it's not a helpful error you've been
> given back so that should be improved.  

Yep, I seeked gogol for that and only get a very few answers, most of
them linking to PG source or unrelated.
 
> What do you get if you perform the exact same INSERT without the COLLATE parts?  

Works (of course, see above) perfectly:
INSERT INTO tst1m VALUES ( default, 
	'źŠÿǚŦÍÏÔJŽććżûŘäpèăîÍŢŃDµŴŻĊĜÿG' , 
	'úĽčŏṻŗĿÁťħĵŇğŚáÛĨæħŽīhĴÝUĶďeźİīŇč'  );
INSERT 0 1

JY
-- 
Love is the only game that is not called on account of darkness.
		-- M. Hirschfield