Re: Schema version management

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Dimitri Fontaine" <dimitri(at)2ndquadrant(dot)fr>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Christopher Browne" <cbbrowne(at)gmail(dot)com>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Schema version management
Date: 2012-07-06 13:55:47
Message-ID: C4DAC901169B624F933534A26ED7DF310861B611@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

Is it imaginable to additionally generate an index file that map the
"half friendly" file names to a cleartext object signature ?

This would allow user to possibly postprocess the output while merging
overloaded functions to single files or renaming the files according to
their needs and preferences...

best regards,

Marc Mamin

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Robert Haas
> Sent: Freitag, 6. Juli 2012 15:02
> To: Dimitri Fontaine
> Cc: Tom Lane; Christopher Browne; Pg Hackers
> Subject: Re: [HACKERS] Schema version management
>
> On Fri, Jul 6, 2012 at 8:23 AM, Dimitri Fontaine
> <dimitri(at)2ndquadrant(dot)fr> wrote:
> > Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> >> This argument seems a bit irrelevant to me. pg_dump doesn't get to
> pick
> >> and choose what will be in the database it's told to dump. If
we're
> >
> > Sure.
> >
> >> going to do something like what Joel wants, we have to have file
> naming
> >> conventions for operator and cast objects. So we can't just leave
> them
> >> out of the conversation (or if we do, we shouldn't be surprised
when
> the
> >> ensuing design sucks).
> >
> > I guess what we're saying is that at this point we can pick non user
> > friendly naming rules, like pg_operator/<oid>.sql or something like
> > that, OID based. Impacted users might as well learn about
extensions.
>
> I think that would defeat some of the human-readability goals that
> people have for this feature, not to mention that it would lose the
> ability to do diff -r between a dump produced on cluster A and a dump
> produced on cluster B.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2012-07-06 14:06:56 Re: Covering Indexes
Previous Message Bruce Momjian 2012-07-06 13:41:01 Re: Covering Indexes