From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Joel Jacobson <joel(at)trustly(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Schema version management |
Date: | 2012-07-05 00:38:04 |
Message-ID: | CA+TgmoZRxfYVQ_pM=S_=tMEM355SWgaGPkCMsk24+6FFDpcbuA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Jul 4, 2012 at 9:02 AM, Joel Jacobson <joel(at)trustly(dot)com> wrote:
> On Tue, Jul 3, 2012 at 7:49 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>>
>> I think this idea has merit. Prepare a patch and put it into the next
>> commit fest.
>
> Glad to hear, I'm on it!
>
>>
>> I see the problem that since the dump order is in general not
>> deterministic, this will cause random reordering in your master file
>> that includes all the individual files.
>>
>>
>> Then again, making the dump order deterministic is a problem that can be
>> solved (I suppose), so maybe starting there would be a good step. But
>> it will require a small amount of in-depth pg_dump hacking.
>
>
> I just made a test, where I created objects in different order and compared
> the dumps.
> It appears pg_dump dumps objects in alphabetically sorted order.
> This works fine for most objects, but not for overloaded functions, in which
> case
> they are dumped in oid order.
>
> Are there any other cases than overloaded functions, where the dump order
> isn't deterministic?
>
> While waiting for your reply, I'll be working on fixing the problem with
> overloaded functions.
My vote is - when there's an overloaded function, put each version in
its own file. And name the files something like
functionname_something.sql. And just document that something may not
be entirely stable.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2012-07-05 01:04:53 | Re: Patch: add conversion from pg_wchar to multibyte |
Previous Message | Robert Haas | 2012-07-05 00:36:06 | Re: Pg default's verbosity? |