Excerpts from Greg Sabino Mullane's message of lun may 30 12:00:43 -0400 2011:
> 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.
So 19183 is the toast table OID?
--
Ãlvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support