Re: [PATCH] pg_dump: Sort overloaded functions in deterministic order - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: [PATCH] pg_dump: Sort overloaded functions in deterministic order
Date
Msg-id CAASwCXcshrZ2oWGdK_-O0vMVs8DnOV75d+-c9iGvv2C5aJepnw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] pg_dump: Sort overloaded functions in deterministic order  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [PATCH] pg_dump: Sort overloaded functions in deterministic order  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Wed, Oct 17, 2012 at 11:43 PM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> Uh, the patch you posted keeps the pg_get_function_identity_arguments
> call in dumpFunc, but there is now also a new one in getFuncs.  Do we
> need to remove the second one?

It could be done, but unfortunately we cannot use the value computed
in dumpFunc(),
because getFuncs() is called before dumpFunc().

The patch currently only affects getFuncs(), it doesn't touch dumpFunc().

What could be done is to keep the changes in getFuncs(), and also
change dumpFunc()
to use the value computed in getFuncs(), but I think the gain is small
in relation
to the complexity of changing dumpFunc(), as we would still need to
make the two other
function calls in the SQL query in dumpFunc() to pg_get_function_arguments() and
pg_get_function_result().


> Here's an updated patch for your consideration.  I was about to push
> this when I noticed the above.  The only change here is that the extra
> code that tests for new remoteVersions in the second "else if" branch of
> getFuncs and getAggregates has been removed, since it cannot ever be
> reached.

Looks really good.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Bugs in CREATE/DROP INDEX CONCURRENTLY
Next
From: Dimitri Fontaine
Date:
Subject: Re: Global Sequences