On Tue, Feb 27, 2007 at 10:30:15AM +0100, Magnus Hagander wrote:
> > Does Windows have a method to get a unique ID number for a given data
> > directory, or a token file in that directory? It would need to be
> > constant while the database is open. Perhaps
> > GetFileInformationByHandle? It returns a struct with a nFileIndex
> > value that seems to be that, although I'm not certain.
> > This might make it easier to avoid the complexity of fitting the
> > filename in the segment name, and avoid the rename problem,
> Yes, you could use the fileindex value. You need that one and the volume
> serial number, total of 64+32 bits of data.
> So yeah, we cuold use that instead of the full path name if we want to.
> The advantage of this one is that it's shorter, the advantage of the
> full path name is that you can see where the backend is from.
> However, in most cases you will be able to see where the backend is from
> anyway, because it is likely to have some other file open in the data
> directory, so maybe that isn't such a big point after all?
Actually, I'm not sure we can. It's only stable as long as someone has
the file open. It will change if it's closed and re-opened later.
Given that we don't actually open the directory, and only files inside
it, I don't know how that works.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not