Yes, thanks very much! - DAP
>-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Lareau >Sent: Thursday, January 27, 2005 8:10 PM >To: Tom Lane >Cc: Kenneth Lareau; pgsql-hackers@postgresql.org >Subject: Re: [HACKERS] Strange issue with initdb on 8.0 and >Solaris automounts > >In message <[EMAIL PROTECTED]>, Tom Lane writes: >>Kenneth Lareau <[EMAIL PROTECTED]> writes: >>> In message <[EMAIL PROTECTED]>, Tom Lane writes: >>>> Could you truss that and see what it does? >> >>> Here's the relevant truss output from 'mkdir >/software/postgresql-8.0.0' >>> on my Solaris 9 system: >> >>> 10832: mkdir("/software/postgresql-8.0.0", 0777) >Err#89 ENOSYS >>> 10832: stat64("/software/postgresql-8.0.0", 0xFFBFFA38) = 0 >> >>> It's doing the stat after the mkdir attempt it seems, and >coming back >>> with the correct response. Hmm, maybe I should look at the >Solaris 8 >>> code for the mkdir command... >> >>Well, the important point is that the stat does succeed. I'm >not going >>to put in anything as specific as a check for ENOSYS, but it seems >>reasonable to try the stat first and mkdir only if stat fails. >>I've applied the attached patch. >> >> regards, tom lane > > >Tom, thank you very much for the patch, it worked like a charm. > > >Ken Lareau >[EMAIL PROTECTED] > >---------------------------(end of >broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index >scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings