non-standard 'CREATE INDEX' problem

From: n0g0013 <ttw+pg(at)cobbled(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: non-standard 'CREATE INDEX' problem
Date: 2006-10-04 16:37:26
Message-ID: 20061004163726.GA28791@holyman.cobbled.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

--
t
t
w

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sebastian Reitenbach 2006-10-05 04:24:17 Re: postgres in HA constellation
Previous Message Brad Nicholson 2006-10-04 16:05:02 Re: postgres in HA constellation