From: Michael Fuhr <mike@fuhr.org>
To: andy rost <andy.rost@noaa.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: sqlstate 02000 while declaring cursor/freeing prepared statements
Date: Mon, 29 Aug 2005 14:09:35 -0600
Message-ID: <20050829200935.GA98664@winnie.fuhr.org> (raw)
In-Reply-To: <431361D8.8050900@noaa.gov>
References: <431361D8.8050900@noaa.gov>
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?
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, andy.rost@noaa.gov
Subject: Re: sqlstate 02000 while declaring cursor/freeing prepared statements
In-Reply-To: <20050829200935.GA98664@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox