Re: Proposal: PL/PgSQL strict_mode - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Proposal: PL/PgSQL strict_mode
Date
Msg-id 52342BB8.4040506@joh.to
Whole thread Raw
In response to Re: Proposal: PL/PgSQL strict_mode  (chris travers <chris@2ndquadrant.com>)
List pgsql-hackers
On 14/09/2013 06:53, chris travers wrote:
> I am going to suggest that STRICT is semantically pretty far from what is meant
> here in common speech.  I think STRICT here would be confusing.  This would be
> really pretty severe for people coming from Perl or MySQL backgrounds.

The name of the feature doesn't really matter.  I chose STRICT because 
the behaviour is somewhat similar to INTO .. STRICT.

> May I suggest SINGLE as a key word instead?  It might be worth having attached
> to a INSERT, UPDATE, and DELETE statements.

I already suggested the "attach a keyword to every statement" approach, 
and got shot down quite quickly.


Regards,
Marko Tiikkaja



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Next
From: samthakur74
Date:
Subject: Re: pg_stat_statements: calls under-estimation propagation