Jon V <jon@cecorp.com> writes:
> On the development/test machine (pg 7.2.3, odbc 7.1.9, pgadmin 1.2.0),
> you can put a query inside begin/end statements and get the results. e.g.
> begin;
> select * from table_name;
> end;
> returns the table contents.
> We have several other machines, running various combinations, e.g.
> pg 7.3.1, odbc 7.2.5, pgadmin 1.4.12
> pg 7.2.1, odbv 7.2.3, pgadmin 1.2.0
> and with those we just get a "query OK" message. It obviously does the
> query, but it doesn't display the results.
Ugh.
> Which behavior is "right", and is there something we can do to see the
> results?
I'd definitely say the former is right.
It's hard to be sure which component is at fault, but just comparing
version numbers the odbc 7.1.x -> 7.2.x update seems like the biggest
change. I'd suggest seeking help on the pgsql-odbc mailing list.
regards, tom lane