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(at)crankycanuck(dot)ca
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