Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Andrew Sullivan
On Fri, Jun 08, 2007 at 11:11:05AM -0400, Tom Lane wrote: > > I wonder if Slony is doing it to you --- somehow deciding it needs to > "replicate" that table from somewhere else. Might be worth inquiring > on the slony lists if anyone's seen such a thing. The only way Slony would do that is in th

[GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Andrew Edson
The company I work for provides services for various offices around the country. In order to help keep our database straight, and allow several of our client-side programs to verify their location, we include a table called 'region' in our database. Although the database is replicated by Slony

Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Andrew Sullivan
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 cor

Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Tom Lane
Andrew Edson <[EMAIL PROTECTED]> writes: > Does anyone have any suggestions as to what could be causing this > single table to lose its data? I wonder if Slony is doing it to you --- somehow deciding it needs to "replicate" that table from somewhere else. Might be worth inquiring on the slony

Re: [GENERAL] Disappearing table - suggestions on possible causes appreciated.

2007-06-08 Thread Bill Moran
In response to Andrew Edson <[EMAIL PROTECTED]>: > The company I work for provides services for various offices around the > country. In order to help keep our database straight, and allow several of > our client-side programs to verify their location, we include a table called > 'region' in o