Collate is not supported for 7.4

[Zengfa Gao]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings