Re: Tables dissapearing - Mailing list pgsql-general

From brian
Subject Re: Tables dissapearing
Date
Msg-id 46D2EFA8.6000602@zijn-digital.com
Whole thread Raw
In response to Re: Tables dissapearing  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
List pgsql-general
Tom Lane wrote:
> Kamil Srot <kamil.srot@nlogy.com> writes:
>
>>One more thing:
>>The project runs proprietal CMS system and there are more instances of
>>it with the same database layout in different databases. Every time the
>>"lost" table is the same one - the bussiest one (mostly read)... and
>>everytime the "lost" table is gone from more projects at once... today
>>it was 2 projects affected out of 7 in the same pgsql server... it looks
>>also like the problem happens everytime short after midnight - scarry -
>>ha ha :-)
>
>
> Tables don't just "disappear" like that.  Check your application code
> to see if it's not dropping the table someplace.
>
>             regards, tom lane
>

grep -i drop your_application_dir

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ERROR] syntax error at end of input
Next
From: Tom Lane
Date:
Subject: Re: Out of Memory - 8.2.4