| 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)
| 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 |