On Wed, Jun 25, 2008 at 01:24:06PM +0530, Pradeepa wrote: > Hi Team, > > We want some information like, if any one deletes database from postgres, > how to trace when it has been deleted. The deletion is not from any command > but by right clicking on db and deleting it.
Uh, how is that "right clicking" happening? What interface are you using? The delete is happening by _some_ command. Anyway, you can do this with triggers. There's an example of doing this in the manual, I believe. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs