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