Re: Disappearing table - suggestions on possible causes appreciated.

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 the event that the table were
added to a set. In that case, it will indeed truncate the table and
try to load the data from the origin. So that is a possibility I
didn't list in my other mail. If the table is large, the load could
take some time, during which you'd not be able to see anything in the
table. When you went to insert to the table, though, you'd get
errors, so unless you're dropping the table and rebuilding from
scratch, I'd expect you to get an error when you reloaded the data.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Everything that happens in the world happens at some place.
--Jane Jacobs