| From: | Niklas Langvig <niklas(dot)langvig(at)globesoft(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | syntax error collate |
| Date: | 2012-10-03 14:31:21 |
| Message-ID: | F07D92605693874883FC5F6E4FB1A85130789AC4B3@Globe-Exch03.globesoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
We get the same error if we run psql (with the same create collation query) under linux too.
Thanks
Niklas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Sosinski | 2012-10-03 14:33:49 | Postgres will not start due to corrupt index |
| Previous Message | Leonardo M. Ramé | 2012-10-03 14:21:57 | Upgrading 8.3-rc1 to 8.3.20 |