Re: PL/pgSQL 2 - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: PL/pgSQL 2
Date
Msg-id CAASwCXct9c5=39KoBS3YR7kqWrOeritGzBCvdiWqkN+xkJVGJw@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL 2  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: PL/pgSQL 2
Re: PL/pgSQL 2
List pgsql-hackers
On Tue, Sep 2, 2014 at 2:29 PM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> In the mailing list thread that you linked there, Tom suggested using
> "STRICT UPDATE ..." to mean that updating 0 or >1 rows is an error
> (http://www.postgresql.org/message-id/16397.1356106923@sss.pgh.pa.us). What
> happened to that proposal?

From the STRICT mail thread, this was the last post:

>"Marko Tiikkaja" <marko@joh.to> writes:
>> If I'm counting correctly, we have four votes for this patch and two votes
>> against it.
>> Any other opinions?
>
>FWIW, I share Peter's poor opinion of this syntax.  I can see the
>appeal of not having to write an explicit check of the rowcount
>afterwards, but that appeal is greatly weakened by the strange syntax.
>(IOW, if you were counting me as a + vote, that was only a vote for
>the concept --- on reflection I don't much like this implementation.)
>regards, tom lane

I think it's much better to make it the default behaviour in plpgsql2
than to add a new syntax to plpgsql,
because then we don't have to argue what to call the keyword or where to put it.



pgsql-hackers by date:

Previous
From: Arthur Silva
Date:
Subject: Re: [REVIEW] Re: Compression of full-page-writes
Next
From: Tomonari Katsumata
Date:
Subject: Re: proposal: rounding up time value less than its unit.