Unlogged tables cannot be truncated twice - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Unlogged tables cannot be truncated twice
Date
Msg-id 20110530160043.GC3012@core.home
Whole thread Raw
Responses Re: Unlogged tables cannot be truncated twice
List pgsql-bugs
Wow, this one took a bit to narrow down. Here's the failing case:

# create unlogged table foo (a text);
CREATE TABLE
# begin;
BEGIN
#* truncate table foo;
TRUNCATE TABLE
#* truncate table foo;
ERROR:  could not create file "base/19131/19183_init": File exists

Very reproducible. The column types matter: if the only column=20
is an INT, for example, the problem does not occur.

--=20
Greg Sabino Mullane greg@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong struct size
Next
From: Alvaro Herrera
Date:
Subject: Re: 9.1 plperlu bug with null rows in trigger hash