Re: WIP: default values for function parameters - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WIP: default values for function parameters
Date
Msg-id 16586.1228067371@sss.pgh.pa.us
Whole thread Raw
In response to Re: WIP: default values for function parameters  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: WIP: default values for function parameters  ("David E. Wheeler" <david@kineticode.com>)
Re: WIP: default values for function parameters  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> There are two ways to fix this, both having some validity:

> 1. We create a second version of pg_get_function_arguments() that produces 
> arguments without default values decoration.  This is probably the 
> technically sound thing to do.

Yes.  I think that the argument for allowing parameter names in commands
like ALTER FUNCTION is that the user might consider them part of the
function's identity.  This can hardly be claimed for default values.

Also, there's a third possibility: we could revert the decision to allow
pg_dump to depend on pg_get_function_arguments in the first place.  That
was really the lazy man's approach to begin with.  The more we allow
pg_dump to depend on backend functions that work in a SnapshotNow world,
the more risk we have of producing inconsistent dumps.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: WIP: default values for function parameters
Next
From: "David E. Wheeler"
Date:
Subject: Re: WIP: default values for function parameters