Re: Unhappy thoughts about pg_dump and objects inherited from template1

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Unhappy thoughts about pg_dump and objects inherited from template1
Дата
Msg-id 200011091436.JAA01260@jupiter.jw.home
обсуждение исходный текст
Ответ на Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Maurizio"
Дата:
Сообщение: Re: [INTERFACES] USE OF CURSORS IN ECPG
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Unhappy thoughts about pg_dump and objects inherited from template1