| From: | Matthew Wakeling <mnw21(at)cam(dot)ac(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: CREATE DATABASE vs delayed table unlink |
| Date: | 2008-10-09 12:50:07 |
| Message-ID: | alpine.DEB.1.10.0810091345280.15851@aragorn.flymine.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 9 Oct 2008, Tom Lane wrote:
> So I'm mystified
> how Matthew could have seen the expected error and yet had the
> destination tree (or at least large chunks of it) left behind.
Remember I was running 8.3.0, and you mentioned a few changes after that
version which would have made sure the destination tree was cleaned up
properly.
> [ thinks for a bit... ] We know there were multiple occurrences.
> Matthew, is it possible that you had other createdb failures that
> did *not* report "file does not exist"? For instance, a createdb
> interrupted by a "fast" database shutdown might have left things this
> way.
Well, we didn't have any fast database shutdowns or power failures. I
don't think so.
Matthew
--
Heat is work, and work's a curse. All the heat in the universe, it's
going to cool down, because it can't increase, then there'll be no
more work, and there'll be perfect peace. -- Michael Flanders
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Cox | 2008-10-09 13:37:37 | TODO item: adding VERBOSE option to CLUSTER |
| Previous Message | Tom Lane | 2008-10-09 12:47:08 | Re: autovacuum and reloptions |