On Fri, Jun 08, 2007 at 07:39:26AM -0700, Andrew Edson wrote: > Recently, there have been incidents across a few of the offices > where the region table in their local copy of the database has > mysteriously lost all of its data. Well, a couple possibilities: 1. Are you vacuuming correctly? If you had xid wraparound, your data could disappear. 2. Malice or pilot error: are you sure nobody has issued TRUNCATE on the table? A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz