Re: Review handling of MOVE and FETCH (ToDo) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Review handling of MOVE and FETCH (ToDo)
Date
Msg-id 13930.1254318707@sss.pgh.pa.us
Whole thread Raw
In response to Re: Review handling of MOVE and FETCH (ToDo)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On Mon, 2009-09-28 at 10:44 -0700, John Naylor wrote:
>> + errmsg("statement FETCH returns more rows."),
>> + errhint("Multirows fetch are not allowed in PL/pgSQL.")));
>> 
>> This might sound better as "statement FETCH returns multiple rows.",

> errmsg should be without period.

>> and "Multirow FETCH is not allowed in PL/pgSQL."

> That might better be errdetail.

It got committed like this:
           ereport(ERROR,                   (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),                    errmsg("FETCH
statementcannot return multiple rows")));
 

I didn't think the HINT was adding anything useful ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [PATCH] Reworks for Access Control facilities (r2311)
Next
From: Alvaro Herrera
Date:
Subject: Re: TODO item: Allow more complex user/database default GUC settings