Re: drop tablespace error: invalid argument

Jan Otto <asche@me.com> writes:

ERROR:  could not read directory "pg_tblspc/16464": Invalid argument

STATEMENT:  DROP TABLESPACE testspace;

I have digged a bit around in the source code of postgresql to build a

self contained test-case for Apple and found that the implementation

of Apples readdir() is buggy. readdir() fails under some circumstances.

So i have build a patch against current pgsql's HEAD to work around

the issue. If the bug in readdir() goes into the final release  snow leopard

we have a solution. 

This patch basically frees dirdesc and rereads the tablespace location

in case a subdirectory was deleted from the tablespace. this is the place

where snow leopard fails to read the next entry with readdir().