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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs