Re: dropping sequences

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Erik Price <eprice(at)ptc(dot)com>
Cc: Doug McNaught <doug(at)mcnaught(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: dropping sequences
Date: 2003-06-20 17:14:25
Message-ID: Pine.LNX.4.33.0306201113190.10453-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 20 Jun 2003, Erik Price wrote:

>
>
> Doug McNaught wrote:
>
> > Actually, I'm pretty sure it's "template1". Where in the docs does it
> > say "template0"?
>
> Maybe it is template1. I have a DB on my system named template0, but I
> might have created that right when I first installed PostgreSQL as an
> experiment and forgot about it. I also have a template1 database.

Actually, template0 is the "oh dear god, what have I done to template1"
recovery database that the initdb script (now program) creates when run.

template1 is the "hey, if i add a language here, all my new databases get
it too" database.

You generally can't connect to tempalte0, by the way.

Just all FYI.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-06-20 17:21:30 Re: Incremental backups, and backup history
Previous Message Tom Lane 2003-06-20 17:01:14 Re: [HACKERS] psql