Re: Controlling changes in plpgsql variable resolution - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Controlling changes in plpgsql variable resolution
Date
Msg-id 162867790910191017m75943cf1p244742edea9fbfea@mail.gmail.com
Whole thread Raw
In response to Re: Controlling changes in plpgsql variable resolution  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Controlling changes in plpgsql variable resolution
List pgsql-hackers
2009/10/19 Kevin Grittner <Kevin.Grittner@wicourts.gov>:
> "David E. Wheeler" <david@kineticode.com> wrote:
>
>> I'd be in favor of a GUC that I could turn on to throw an error
>> when there's an ambiguity.
>
> I would consider hiding one definition with another very bad form, so
> I would prefer to have plpgsql throw an error when that happens.  I
> don't particularly care whether that is the only supported behavior or
> whether there's a GUC to control it, or what its default is, if
> present.
>

ambiguous identifiers is probably the top reason of some plpgsql's
mysterious errors. More times I found wrong code - sometime really
important (some security checks). I never found good code with
ambiguous identifiers - so for me, exception is good. But - there will
be lot of working applications that contains this hidden bug - and
works "well". So it could be a problem. GUC should be a solution.

Pavel


> -Kevin
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rejecting weak passwords
Next
From: Merlin Moncure
Date:
Subject: Re: Controlling changes in plpgsql variable resolution