Home > Archive > PostgreSQL Administration > October 2006 > Re: non-standard 'CREATE INDEX' problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: non-standard 'CREATE INDEX' problem
Jim Nasby

2006-10-25, 8:24 am

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)



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com