Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group