Search Postgresql Archives

Re: Disappearing table - suggestions on possible causes appreciated.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx
Everything that happens in the world happens at some place.
		--Jane Jacobs 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux