Re: WIP: Allow SQL-language functions to reference parameters by parameter name - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Date
Msg-id m27hah6op5.fsf@hi-media.com
Whole thread Raw
In response to Re: WIP: Allow SQL-language functions to reference parameters by parameter name  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
(oops this mail never reached out, it seems, resending)

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah, I've come round to that position too.  I think allowing
>> parameter names to be checked only after query names is probably
>> the best answer.
>
> That seems the most useful and least surprising approach to me.

Allow me to disagree.  I don't want to recheck all my SQL functions
whenever I ALTER TABLE … ADD|DROP|RENAME COLUMN …;

We don't even have a nice way to list functions dependencies towards
objects that are part of their body to help me out here, or do we?

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: new AM, catalog entries
Next
From: Merlin Moncure
Date:
Subject: Re: Proposal - asynchronous functions