Re: non-standard 'CREATE INDEX' problem

From: Jim Nasby <jim(at)nasby(dot)net>
To: n0g0013 <ttw+pg(at)cobbled(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: non-standard 'CREATE INDEX' problem
Date: 2006-10-10 20:44:00
Message-ID: 63C268BA-3B33-4056-BCC9-97B4CE538294@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Ray 2006-10-10 21:07:19 Re: How to remove a superuser
Previous Message Jim C. Nasby 2006-10-10 20:41:23 Re: How to remove a superuser