Re: Programmatically dropping and creating table

"Chris White" <cjwhite@cisco.com> writes:
>> Are you *certain* you are talking to a 7.2 backend?

> It gives me PostgresSQL 7.2.1.

Drat, so much for that theory.

I think whatever's going wrong must be at a fairly low level.  Can you
try strace'ing the backend process that's handling your connection to see
exactly what file name it's trying to create when you give this command?
It should be something like

    path-to-pgdata-dir/base/oid-of-db/oid-of-new-file

issued in an open() kernel call with O_CREAT and O_EXCL flags set.

            regards, tom lane