Thread: Collate is not supported for 7.4

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

On Wednesday 14 January 2004 16:10, Zengfa Gao wrote:
>
> 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.

> CREATE TABLE deviceObjValues ( deviceKey int NOT NULL
> , createdBy varchar (128) COLLATE
> SQL_Latin1_General_CP1_CI_AS

> java.sql.SQLException: ERROR:  syntax error at or near
> "COLLATE" at character 83

Well, 7.3 gives:

NOTICE:  CREATE TABLE / COLLATE sql_latin1_general_cp1_ci_as not yet
implemented; clause ignored

So it looks like someone tightened up the parsing definition on the basis that
collate wasn't supported anyway.

--
  Richard Huxton
  Archonet Ltd