Postgres Pro
Downloads
Home   >   mailing lists

Re: non-standard 'CREATE INDEX' problem - Mailing list pgsql-admin

From Jim Nasby
Subject Re: non-standard 'CREATE INDEX' problem
Date
Msg-id 63C268BA-3B33-4056-BCC9-97B4CE538294@nasby.net
Whole thread Raw
In response to non-standard 'CREATE INDEX' problem  (n0g0013 <ttw+pg@cobbled.net>)
List pgsql-admin
Tree view
On Oct 4, 2006, at 12:37 PM, n0g0013 wrote:
got a vendor application that's pretty much designed for MSSQL but
it's using 'CREATE INDEX ... [ ASC | DESC ]' syntax.

it appears that the ODBC driver is rejecting that as invalid.
testing on the database reveals the same.  and reference to the docs
indicate it's not postgresql syntax.

is there a quick hack allow the driver and the database to accept the
syntax?

Quick? Not really. You'd have to modify the grammar, at a minimum.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: How to remove a superuser
Next
From: Richard Ray
Date:
Subject: Re: How to remove a superuser