Warning for undefined cursor

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Warning for undefined cursor
Date: 2003-07-28 09:10:39
Message-ID: Pine.LNX.4.56.0307281106590.2256@krusty.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-07-28 09:26:55 Assignment scheme for implementation-defined error codes?
Previous Message Shridhar Daithankar 2003-07-28 08:59:36 Doubt w.r.t vacuum