On Thu, Jan 17, 2008 at 11:14:22AM -0800, Glyn Astill wrote: > > begin; > > set transaction isolation level serializable; > > > > --- begin dumping stuff; > > > > Wouldn't that just lock everything so nothing could be updated? Or > just the table it is outputting? PostgreSQL uses MVCC, which means the whole thing is lock free. It just requires more diskspace. To keep the older versions around. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
