From: | "Dmitry Samokhin" <sdld(at)mail(dot)ru> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Table's Field Info |
Date: | 2005-12-30 08:15:39 |
Message-ID: | dp2qb7$1imf$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Working in the following environment:
Borland VCL ADO Components -> Microsoft OLE DB Provider for ODBC Drivers ->
PostgreSQL ODBC Driver -> PostgreSQL Server
and executing SQL statements like this:
SELECT * FROM mytable WHERE ...
I was surprised the driver issues the statement "SELECT * FROM mytable" just
before executing my custom statement. I guess it tries to retreive the field
info for "mytable". But what if "mytable" contains mios of rows?! The
execution will continue forever... Yes, I am aware of the option "Disallow
Premature". But my Borland TADOQuery object crashes on
begin;declare cursor .. for select ...;fetch backward in ..;close ..;commit
(unexpected EOF of client connection)
I think this is the easiest way to get no row but the field info:
SELECT * FROM mytable WHERE 0=1
Isn't it?
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-01-02 11:57:39 | [ psqlodbc-Bugs-1000514 ] Conexo ADO |
Previous Message | noreply | 2005-12-29 21:39:21 | [ psqlodbc-Bugs-1000507 ] MSSQL syntax |