Re: could not create directory "...": File exists - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: could not create directory "...": File exists
Date
Msg-id 20130119185017.GH16126@tamriel.snowman.net
Whole thread Raw
In response to Re: could not create directory "...": File exists  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> I committed this with a couple of changes:

Great, thanks!

> * I used GetLatestSnapshot rather than GetTransactionSnapshot.  Since
> we don't allow these operations inside transaction blocks, there
> shouldn't be much difference, but in principle GetTransactionSnapshot
> is the wrong thing; in a serializable transaction it could be quite old.

Makes sense.

> * After reviewing the other uses of SnapshotNow in dbcommands.c, I
> decided we'd better make the same type of change in remove_dbtablespaces
> and check_db_file_conflict, because those are likewise doing filesystem
> operations on the strength of what they find in pg_tablespace.

Thanks for that.  I had noticed the other places where we were using
SnapshotNow, but I hadn't run down if they needed to be changed or not.

> I also ended up deciding to back-patch to 8.3 as well.

Excellent, thanks again.
Stephen

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: fix corner use case of variadic fuctions usage
Next
From: Stephen Frost
Date:
Subject: Re: My first patch! (to \df output)