Re: Help with version/behavior quirks.

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