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/
