Re: dropping sequences

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Erik Price <eprice(at)ptc(dot)com>, Doug McNaught <doug(at)mcnaught(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: dropping sequences
Date: 2003-06-21 02:27:37
Message-ID: 23188.1056162457@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> On Fri, Jun 20, 2003 at 11:14:25AM -0600, scott.marlowe wrote:
>> Actually, template0 is the "oh dear god, what have I done to template1"
>> recovery database that the initdb script (now program) creates when run.

> I think template0 is also used to compute differences that should be
> written by pg_dump or pg_dumpall. I don't recall the exact details...

This is all covered in TFM ...
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=manage-ag-templatedbs.html

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-21 02:43:49 Re: Unable to create or drop plpgsql
Previous Message Teresa Hasheminejad 2003-06-21 01:43:21 Re: Looking for PERL documentation (fwd)