On 8/27/07, Kamil Srot <kamil.srot@nlogy.com> wrote:
> I really need to make sure, the next problem (if it's necessary to let
> it happen) will be the last one... :-(
Have you set your log_statement to 'ddl' in postgresql.conf?
That way you'll have a log of every single ddl that goes through the
database. At least then when the table disappears again you can look
in your logs to see if it was in fact a client app that did it.
Also, look at taking away permission from anyone BUT the postgres
superuser to drop objects.