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
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
Wayne Armstrong wrote:
>** Reply to message from Jon V <jon(at)cecorp(dot)com> on Mon, 28 Apr 2003 14:37:05
> 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 :)
>>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:
>>select * from table_name
>>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
>>Where should I look?
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2003-04-30 02:17:43|
|Subject: Re: ODBC Behavior, where do I find help?|
|Previous:||From: Miguel Juan||Date: 2003-04-29 08:52:34|
|Subject: Fw: Error:Unable to identify an operator|