pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
non-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