Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group