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

Re: error tryiing to insert with collate

From: Thom Brown <thom(at)linux(dot)com>
To: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: error tryiing to insert with collate
Date: 2012-01-02 15:22:19
Message-ID: CAA-aLv51H5K8Y2YaN5GWn50JsuH+hq-RYKJ2Kdg3JCk8Ei897w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

-- 
Thom

In response to

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2012-01-02 16:02:01
Subject: Re: error tryiing to insert with collate
Previous:From: Jean-Yves F. BarbierDate: 2012-01-02 15:06:26
Subject: error tryiing to insert with collate

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