Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with "create database ... with template " - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with "create database ... with template "
Date
Msg-id 522.1178740949@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with "create database ... with template "  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Problem with "create database ... with template "  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
Oleg Bartunov <oleg@sai.msu.su> writes:
> I tried that connecting to template1, but it doesn't helped. The problem
> occurs even if I repeat 'drop;create' in one connection (the same backend).

Hmm.  Do you have autovacuum turned on?  8.2 isn't real smart about
dealing with autovac running in the template DB ...

FWIW, I could repeat it here easily with the given test case (new
connections being made each time) but not with a single persistent
connection.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Problem with "create database ... with template "
Next
From: Magnus Hagander
Date:
Subject: Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first