Unlogged tables cannot be truncated twice

From: Greg Sabino Mullane <greg(at)endpoint(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Unlogged tables cannot be truncated twice
Date: 2011-05-30 16:00:43
Message-ID: 20110530160043.GC3012@core.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
is an INT, for example, the problem does not occur.

--
Greg Sabino Mullane greg(at)endpoint(dot)com
End Point Corporation
PGP Key: 0x14964AC8

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2011-05-30 17:02:12 Re: 9.1 plperlu bug with null rows in trigger hash
Previous Message Greg Sabino Mullane 2011-05-30 15:26:29 Re: Failed pgbench: setrandom invalid maximum number 0