** Reply to message from Jon V <jon@cecorp.com> on Mon, 28 Apr 2003 14:37:05
-0700
Hi,
Try it without the begin and end;
What you are seeing is the result of the last executed statement (end; )
I don't know if this represents a change in the odbc driver - but it is
behaviour that seems reasonable to me :)
Regards,
Wayne
> Hello all,
>
> I'm sure this is a pretty basic misunderstanding or misapplication on my
> part. I'm hoping one of you can set me straight.
> I'm running PostgreSQL 7.3.2 under Cygwin. Running ODBC 7.01.00.10 (as
> displayed in the ODBC Data Source Administrator Driver tab), my
> application works fine. However, if I install any of the 7.02 ODBC
> drivers, my application fails.
>
> We've traced the cause of the failure, and it has me scratching my head.
> Using our application OR PgAdminII, I run the following:
>
> begin;
> select * from table_name
> end
>
> With 7.1 ODBC I get a result (in PgAdminII a table pops up on the
> screen, in our app we get the results of the query). With 7.2 I get a
> "query completed successfully" (status) message. The same thing happens
> when I run an SQL function we've written that passes a cursor back --
> 7.1 returns the result, 7.2 returns a status.
>
> I assume I must be doing something wrong because if it was really broken
> then nobody could use 7.2, and the latest versions of PgAdmin are quite
> forceful about automatically installing the 7.2 drivers if they aren't
> present.
>
> Where should I look?
>
> TIA,
> Jon
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html