Re: Collate is not supported for 7.4

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