Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 073A69FB418 for ; Wed, 4 Oct 2006 14:04:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05274-08-2 for ; Wed, 4 Oct 2006 14:04:05 -0300 (ADT) X-Greylist: delayed 00:26:27.707485 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8A8869FB316 for ; Wed, 4 Oct 2006 14:04:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp2.irishbroadband.ie (smtp2.irishbroadband.ie [62.231.32.13]) by svr4.postgresql.org (Postfix) with ESMTP id 928275AF074 for ; Wed, 4 Oct 2006 16:37:36 +0000 (GMT) Received: from [87.192.210.164] (helo=holyman.cobbled.net) by smtp2.irishbroadband.ie with esmtps (TLSv1:AES256-SHA:256) (Exim 4.62 (FreeBSD)) (envelope-from ) id 1GV9kU-000Iw6-Pb for pgsql-admin@postgresql.org; Wed, 04 Oct 2006 17:37:35 +0100 Received: from holyman.cobbled.net (localhost [127.0.0.1]) by holyman.cobbled.net (8.13.3/8.13.3) with ESMTP id k94GbRqV003530 for ; Wed, 4 Oct 2006 17:37:27 +0100 (IST) Received: (from fergus@localhost) by holyman.cobbled.net (8.13.3/8.13.3) id k94GbRQp007515 for pgsql-admin@postgresql.org; Wed, 4 Oct 2006 17:37:27 +0100 (IST) Date: Wed, 4 Oct 2006 17:37:26 +0100 From: n0g0013 To: pgsql-admin@postgresql.org Subject: non-standard 'CREATE INDEX' problem Message-ID: <20061004163726.GA28791@holyman.cobbled.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Scan-Signature: 3ec2f1cef14bcb012789e3043bfd1dda X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/26 X-Sequence-Number: 23329 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