John D. Burger wrote:
> Still, I'm trying to figure out how to avoid my screw-up in the
> future.
The good old "don't do everything as root" comes to mind.
> I'm not that familiar with the permissions stuff - is there
> any way to take away "drop DB privileges" from a user, or even all
> users? Again, this is PG 7.4.
There is no specific "drop database" privilege, but only owners or
superusers can drop things. So do your general transactional
operations as some other user.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/