Jayadevan
From: Greg Stark <gsstark@xxxxxxx>
To: Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx>
Cc: Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, Greg Smith <greg@xxxxxxxxxxxxxxx>, Amy Smith <vah123@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
Date: 01/19/2010 04:37 PM
Subject: Re: postgres external table
Sent by: pgsql-general-owner@xxxxxxxxxxxxxx
On Tue, Jan 19, 2010 at 4:41 AM, Craig Ringer
<craig@xxxxxxxxxxxxxxxxxxxxx> wrote:
> How can that work without a transactional file system, though? If the
> external process writes to the file while you're half-way through reading
> it, what's the database to do? In general, how do external tables cope with
> the fact that they're on non-transactional storage?
Well if you use mv to replace the old file with the new one then it
should be safe. Unless your query involves opening the table multiple
times or your transactions are more complex than a single query...
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
DISCLAIMER:
"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."