Re: Unhappy thoughts about pg_dump and objects inherited from template1 - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Unhappy thoughts about pg_dump and objects inherited from template1
Date
Msg-id 200011091436.JAA01260@jupiter.jw.home
Whole thread Raw
In response to Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-hackers by date:

Previous
From: "Maurizio"
Date:
Subject: Re: [INTERFACES] USE OF CURSORS IN ECPG
Next
From: Jan Wieck
Date:
Subject: Re: Unhappy thoughts about pg_dump and objects inherited from template1