Re: Tables dissapearing - Mailing list pgsql-general

From brian
Subject Re: Tables dissapearing
Date
Msg-id 46D35CDC.2010108@zijn-digital.com
Whole thread Raw
In response to Re: Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
Responses Re: Tables dissapearing
List pgsql-general
Kamil Srot wrote:
> brian wrote:
>>
>> IMHO, it's not at all improbable, given that this software is
>> connecting to the same databases you are seeing affected by this
>> phenomenon. Not to mention that it's proprietary, so fewer eyes
>> have gone over it.[1] I suggested earlier grepping for 'drop' in
>> your application. Perhaps you should do the same on the CMS.
>>
>> [1] Not meant as a dig at non-free software.
>
> Understood and I agree. I would accept the possibility to do the most
>  stupid coding error in the world, but there is simply no statement
> manipulating with the schema in the whole project. To be sure, I
> searched thru the sources for /drop/i and didn't found anywhere but
> the pear framework of PHP (some constants and test patterns of user
> statements)... OK, I agree this can be run by some coincidence and so
> I have started to log all statements in the logfile... but still I
> doubt executing the drop statement is the problem...

Just wondering: what's the name of this table? What's its function? I
think you mentioned that it's pretty well static. But what is it
holding? Maybe that'll provide a clue as to where to look.

brian

pgsql-general by date:

Previous
From: Kamil Srot
Date:
Subject: Re: Tables dissapearing
Next
From: Tom Lane
Date:
Subject: Re: Detecting whether a point is in a box.