Re: cursors: SCROLL default, error messages - Mailing list pgsql-hackers

From Neil Conway
Subject Re: cursors: SCROLL default, error messages
Date
Msg-id 1048526621.441.11.camel@tokyo
Whole thread Raw
In response to Re: cursors: SCROLL default, error messages  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: cursors: SCROLL default, error messages
List pgsql-hackers
On Fri, 2003-03-21 at 12:12, Tom Lane wrote:
> I agree that the second of these is bogus.  I'm ambivalent about
> changing the first; it's odd but perhaps there are apps out there
> that depend on it.  Any other opinions out there?

For what it's worth, I noticed that the first (DECLARE CURSOR replacing
existing cursors with the same name) doesn't seem to be allowed by the
SQL spec:

(Section 14.1, Syntax Rules)

1. If a <declare cursor> is contained in an SQL-client module M, then:
       (a) The <cursor name> shall not be equivalent to the <cursor       name> of any other <declare cursor> in M.

Personally, I'm inclined to change both of these cases to result in an
error...

Cheers,

Neil



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange aggregate
Next
From: Tom Lane
Date:
Subject: Re: cursors: SCROLL default, error messages