Re: ODBC does not handle WITH clause

From: Joe Conway <mail(at)joeconway(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC does not handle WITH clause
Date: 2013-05-25 12:42:44
Message-ID: 51A0B1C4.6070007@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/24/2013 05:04 PM, Hiroshi Inoue wrote:
> After further investigation I found that more works are needed to
> support WITH CTE statements properly.
>
> We are preparing for the next release.

Good to hear :-)

> Is it OK to apply a stopgap patch to fix the ERROR message? The
> patch is a one line patch to the current source git but

Maybe, but I think we should also document that CTE statements are not
supported at the moment.

> the patch to 9.1.0200 will be very big.

OK. I'll be happy to help with testing once you are ready.

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQIcBAEBAgAGBQJRoLG+AAoJEDfy90M199hlQiMQAI0sf7UKzDJTub/SMkcNdSAi
khaFaWO9mQdNky15dZtKXk22L7EMAld2gp7L11PiicbSRZ2hGafo+X4r8hB/fT3P
5FNOQ2fhWraTnwb/i92ZEJHCIOuka8JJs0LxL4PYR1mA1kCnmdlGpHlRwMIhC0HM
owC9oOGfYhEnvs1cJ+56ONuObD+Fv0HiKaaN+mxPu2niF41pkkZKBIQGlACgcTLA
0x2epAl2rjwYSbCTZvncQIpG43jg7YjHQr9NJUvFMndh78xepJfy8TkcEjxNyiyM
amA5u51GJts9TzhseB3vkRn7NqkbVSUGQtYcnN8QDekaNUrMOFtkY9eSRDn/2FsJ
nnwfj8rvThA5a4viaJsq08JuLOjfbwKzXuvJ33rsri/MFqg8B+FYcPKKgU/18dik
y137vvD0mTiBdM6GuF8Y2nZJenQkzDc2sMplIcLfnE7f93jEpylv/VTfnIB+ngia
pgTSa6gUFUm8YZvwnha/y66PPtteTtyLDVDwI7Zj1sYes0kfkTJ98qufVnFSDI7z
Mwi4viEGUbsDl44NKTFS4cQjzJbqBZNHAjRNp9hE5/KB51blfq6BW/wC+S4g+5eF
SxSJQR5CjnnTU8yEKJr0dYvFD3q5DWTNRWD9ikkSaem3EuYlK8LH9LC4hw5hwDoI
A/xOWysupzhLh0k4WNAc
=B+Wp
-----END PGP SIGNATURE-----

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Daniel Vogelbacher 2013-05-26 10:38:53 SQL_ERROR on SQLExecute() when using SQL_C_NUMERIC for parameters
Previous Message ter062424 2013-05-24 21:42:54 Re: ODBC SELECT Timeout