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

[Jan Wieck]

Tom Lane wrote:
>
> Do we still need the lastsysoid column in pg_database if we do things
> this way?  Seems like what you really want is to suppress all the
> objects that are in template0, so you really only need one lastsysoid
> value, namely template0's.  The other entries are useless AFAICS.
>
>              regards, tom lane

    Right. All we dump after having a non-accessible template0 is
    the difference to that. So  that  a  dump  will  create  it's
    database  from  that  template0  (no  matter  wherever it was
    created from originally) and "patch" it (i.e.  restoring  all
    diffs) to look like at dump time.


Jan

--

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