Jon V wrote:
>
> OK, the symptom is consistant with your explanation, so that makes sense
> in its way.
>
> I'm not sure how it applies to my greater problem though. Namely, I have
> a function stored in the database that returns a refcursor through 7.1
> and (despite my wishes) a status through 7.2. The symptoms are identical
> to the begin;query;end example, but because it is a function I can't
> remove the begin and end. :(
>
> Someone else must be doing the same sort of thing... has anyone had a
> similar problem?
>
> Is there a trick I've missed? Right now we are stuck with 7.1, but we
> want to use PgAdminII, and the current version seems to auto-install
> odbc 7.2.
> >>Using our application OR PgAdminII, I run the following:
> >>
> >>begin;
> >>select * from table_name
> >>end
Using the 7.2 or later driver, you would get 3 results
for the above chained command sequence.
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/