Re: [HACKERS] Unhappy thoughts about pg_dump and objects inherited fromtemplate1

[Jan Wieck]

Tom Lane wrote:
> Philip Warner <[EMAIL PROTECTED]> writes:
> > Where would you store the value if not in pg_database?
>
> No other ideas at the moment.  I was just wondering whether there was any
> way to delete it entirely, but seems like we want to have the value for
> template0 available.  The old way of hardwiring knowledge into pg_dump
> was definitely not as good.

    To  make  pg_dump  failsafe,  we'd  IMHO  need  to freeze all
    objects that come with template0 copying.

    For now we have oid's 1-16383 hardwired from the  bki  files.
    Some  16384-xxxxx get allocated by initdb after bootstrap, so
    we just need to bump the oid counter at the end of initdb (by
    some  bootstrap  interface  command)  to  lets  say 32768 and
    reject any attempt to touch an object with a lower oid.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== [EMAIL PROTECTED] #