By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

Collate is not supported for 7.4

P: n/a
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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.