Re: pg_dump sort order for functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump sort order for functions
Дата
Msg-id 2041.1263224692@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump sort order for functions  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: pg_dump sort order for functions  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> pg_dump sorts its output first by object type, then by object name, and
> then processes all that for dependencies.  This works well, but for
> overloaded functions this still gives a random sort order that can
> produce annoying diffs in the dump.

> Would it be acceptable to introduce a secondary sort key field into the
> DumpableObject struct that functions would fill with, say, the argument
> types (maybe something like "text,int,int" -- need to play with this a
> little)?

I think you could probably use the existing tag field; no need for a new
one.  The real problem is that an object-type-specific sort rule is a
bit klugy.  IIRC there is discussion of this in the archives already ...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [RRR] CommitFest 2010-01: Call for Reviewers
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_dump sort order for functions