Re: [ADMIN] sqlstate 02000 while declaring cursor/freeing statement

2005-08-30 Thread andy rost
Just so that we can snip this thread, we've confirmed that free cursor and free statement do not affect sqlca structure elements sqlcode and sqlstate. Michael Fuhr wrote: On Tue, Aug 30, 2005 at 09:01:36AM -0500, Thomas F. O'Connell wrote: On Aug 29, 2005, at 2:19 PM, andy

[ADMIN] sqlstate 02000 while declaring cursor/freeing statement

2005-08-29 Thread andy rost
I'm new to the PostgreSQL community so please pardon what is probably a silly question ... 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: