Re: sqlstate 02000 while declaring cursor/freeing prepared

Sure. I'm using ECPG (ecpg -t -r no_indicator -C INFORMIX) in a TRU64
operating system for PostgreSQL version 8.0.2. By occasionally, I mean
that I don't observe this problems for each declare and free statement
that I've encoded - only for a subset of those commands. But I do
observe this problem consistently within that subset - the same command
fails every time for a small number of declares and frees.

Unfortunately, I do not have a case that can be easily reproduced. The
commands that fail are part of a large system.

It seems like an odd error for these kinds of commands.

Thanks ...

Andy

Michael Fuhr wrote:
> On Mon, Aug 29, 2005 at 02:28:24PM -0500, andy rost wrote:
>
>>I'm in the process of porting Informix ESQL to PostgreSQL. I
>>occasionally get sqlcode = 100 and sqlstate = 02000 when declaring
>>cursors or freeing prepared statements. Is this normal? For example:
>>
>> $declare loop1 cursor with hold for
>> select distinct ( tabname )
>> from meta ;
>>
>>results in sqlca.sqlcode = 100 and sqlca.sqlstate = '02000'
>
>
> Could you provide a little more context? Are you using ECPG? What
> version of PostgreSQL are you using? When you say that you
> "occasionally" see this behavior, do you mean that you see it
> consistently with some commands and not with others, or do you mean
> that the same command sometimes does it and sometimes not?
>
> Do you have a reproducible test case? That is, everything that
> somebody could do to reproduce the behavior on their own system?
>

--
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
arost(at)nohrsc(dot)nws(dot)gov
http://www.nohrsc.nws.gov
--------------------------------------------------------------------------------