From: | Zengfa Gao <zfgao(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Collate is not supported for 7.4 |
Date: | 2004-01-14 16:10:44 |
Message-ID: | 20040114161044.5035.qmail@web41003.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, all:
I have a schema definition, worked fine for PostgreSQL
7.2 and 7.3. But I saw errors when I use it on
PostgreSQL 7.4.
Can anyone tell me what's changed in 7.4?
Thanks a lot!
Zengfa
CREATE TABLE deviceObjValues ( deviceKey int NOT NULL
, createdBy varchar (128) COLLATE
SQL_Latin1_General_CP1_CI_AS , createdTime bigint NULL
, modifiedBy varchar (128) COLLATE
SQL_Latin1_General_CP1_CI_AS , modifiedTime bigint
NULL, CONSTRAINT PK_deviceObjValues PRIMARY KEY (
deviceKey ) ) ;
====
java.sql.SQLException: ERROR: syntax error at or near
"COLLATE" at character 83
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
From | Date | Subject | |
---|---|---|---|
Next Message | Edwin Quijada | 2004-01-14 16:36:52 | Recuperation Failed!!!!! |
Previous Message | Martin Marques | 2004-01-14 16:10:23 | Re: Best practice? Web application: single PostgreSQL |