| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Niklas Langvig <niklas(dot)langvig(at)globesoft(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: syntax error collate |
| Date: | 2012-10-03 19:41:03 |
| Message-ID: | 506C94CF.7060207@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2012-10-03 19:51:52 | Re: Postgres will not start due to corrupt index |
| Previous Message | Moshe Jacobson | 2012-10-03 19:14:08 | Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? |