Re: syntax error collate

On 03/10/2012 15:31, Niklas Langvig wrote:
> Hello
> If I do this from pgAdmin on windows to my localhost database 9.2 it
> works fine
> CREATE COLLATION Test (
>
>     LOCALE = 'en_US.UTF-8'
>
> )
>
>
> If I connect to a linux server and do the sameI get
>
> ERROR:  syntax error at or near "COLLATION"
>
> LINE 1: CREATE COLLATION Test (
>
> On linux we have version string
>
> PostgreSQL 9.0.3 on x86_64-unknown-linux-gnu
>
> On my windows computer I have PostgreSQL 9.2.1
>
> Does anyone have some ideas what the problem might be.


A quick look at the docs indicates that CREATE COLLATION doesn't exist
in 9.0; it was introduced in 9.1.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie