Re: ODBC Behavior, where do I find help?

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.

Thanks,
-Jon

Wayne Armstrong wrote:

>** Reply to message from Jon V <jon(at)cecorp(dot)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
>>
>>