Thread: non-standard 'CREATE INDEX' problem
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
On Oct 4, 2006, at 12:37 PM, n0g0013 wrote:
got a vendor application that's pretty much designed for MSSQL butit'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 docsindicate it's not postgresql syntax.is there a quick hack allow the driver and the database to accept thesyntax?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)