On 2 January 2012 15:06, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> 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?
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. In any case, it's not a helpful error you've been
given back so that should be improved.
What do you get if you perform the exact same INSERT without the COLLATE parts?
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2012-01-02 16:02:01|
|Subject: Re: error tryiing to insert with collate|
|Previous:||From: Jean-Yves F. Barbier||Date: 2012-01-02 15:06:26|
|Subject: error tryiing to insert with collate|