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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
