Re: Dump and Restore of Database by User

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hubert(dot)palme(at)web(dot)de (Hubert Palme)
Cc: postgresql-bug <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Dump and Restore of Database by User
Date: 2003-04-08 03:06:30
Message-ID: 23840.1049771190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hubert(dot)palme(at)web(dot)de (Hubert Palme) writes:
> ... On the other hand, the language PL/pgSQL is available
> by default in template1,

Not in a default installation.

More to the point: pg_dump cannot assume that the contents of template1
are the same in the destination installation as they were in the source,
so it does not rely on template1 to supply anything.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Venkataseshareddy.Gotham 2003-04-08 06:15:39 FW: sql exception problem
Previous Message Ennio-Sr 2003-04-07 22:19:00 Re: Psql 'Expanded display (\x)' behaviour