
Found it:

Change, in backend/access/nbtree/nbtsort.c:

#define TAPETEMP                "pg_btsortXXXXXX"

to:

#define TAPETEMP                "pg_btsortXXXXXXX"

For some reason, under FreeBSD, it appears that the mktemp() value needs
the extra 'X' to improve/ensure uniqueness



Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Sat, 21 Feb 1998 15:23:45 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
FreeBSD/mktemp bug with create index...fixed