Ragnar <[EMAIL PROTECTED]> writes: > for that matter, what happens if one transaction is using or > even reading an image while another is updating it?
I believe that this also depends on how the file is updated. Some applications create a temporary file with the new (or changed) content and then replace the old file with this one. There are also cases where you can keep a file descriptor open to one file that has no name (it existed once) and that was replaced. It all depends on how / who's generating and how / who's consuming the information. -- Jorge Godoy <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/