X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 63CA1D7E3F for ; Mon, 29 Aug 2005 16:28:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75011-02 for ; Mon, 29 Aug 2005 19:28:25 +0000 (GMT) Received: from home.nohrsc.nws.gov (home.nohrsc.nws.gov [192.46.108.2]) by svr1.postgresql.org (Postfix) with ESMTP id C3E9ED7E12 for ; Mon, 29 Aug 2005 16:28:24 -0300 (ADT) Received: from noaa.gov (opps-gw.nohrsc.nws.gov [192.46.108.142]) by home.nohrsc.nws.gov (Postfix) with ESMTP id 98544A5D2 for ; Mon, 29 Aug 2005 14:28:24 -0500 (CDT) Message-ID: <431361D8.8050900@noaa.gov> Date: Mon, 29 Aug 2005 14:28:24 -0500 From: andy rost User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: sqlstate 02000 while declaring cursor/freeing prepared statements Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/268 X-Sequence-Number: 22496 I'm new to the PostgreSQL community so please pardon what is probably a silly question. Also, this is my first attempt at posting so you might have seen this already (Sorry!) ... 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' -- -------------------------------------------------------------------------------- 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@nohrsc.nws.gov http://www.nohrsc.nws.gov --------------------------------------------------------------------------------