pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feednon-standard 'CREATE INDEX' problem
2+ messages / 2 participants
[nested] [flat]
* non-standard 'CREATE INDEX' problem
@ 2006-10-04 16:37 n0g0013 <ttw+pg@cobbled.net>
0 siblings, 1 reply; 2+ messages in thread
From: n0g0013 @ 2006-10-04 16:37 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: non-standard 'CREATE INDEX' problem
@ 2006-10-10 20:44 Jim Nasby <jim@nasby.net>
parent: n0g0013 <ttw+pg@cobbled.net>
0 siblings, 0 replies; 2+ messages in thread
From: Jim Nasby @ 2006-10-10 20:44 UTC (permalink / raw)
To: n0g0013 <ttw+pg@cobbled.net>; +Cc: 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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-10-10 20:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-04 16:37 non-standard 'CREATE INDEX' problem n0g0013 <ttw+pg@cobbled.net>
2006-10-10 20:44 ` Jim Nasby <jim@nasby.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox