Re: Warning for undefined cursor - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Warning for undefined cursor
Date
Msg-id 200307302159.h6ULxwq14354@candle.pha.pa.us
Whole thread Raw
In response to Warning for undefined cursor  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter, you have brought up some good items recently.  Are you going to
handle them or do you want them added to the TODO list or 7.4 open items
list.


---------------------------------------------------------------------------

Peter Eisentraut wrote:
> In backend/commands/portalcmds.c we have
> 
>         /* FIXME: shouldn't this be an ERROR? */
>         ereport(WARNING,
>                 (errcode(ERRCODE_UNDEFINED_CURSOR),
>                  errmsg("portal \"%s\" does not exist", stmt->portalname)));
> 
> The effect of this is that you can fetch from an undefined cursor and
> (successfully) get zero rows plus this warning.  I propose that we change
> this to an error.  Does anyone see a reason against this, except possibly
> bugward compatibility?
> 
> -- 
> Peter Eisentraut   peter_e@gmx.net
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Some macros for error field codes
Next
From: Tom Lane
Date:
Subject: Any unapplied patches out there?