Gevik Babakhani wrote: > Hi > > On Mon, 2006-04-24 at 23:07 -0400, Alvaro Herrera wrote: > > Gevik Babakhani wrote: > > > > > If one is going to revoke the last ACL_CONNECT, a warning is going to > > > issued then that part of the REVOKE gets canceled. > > > > Humm, no, the WARNING is issued but the REVOKE is executed anyway. > > I have tested this by applying the patch-0.4.diff of a new src tree.
My point is that the behavior you describe is broken. The warning should be issued but the command should be executed anyway. That way the user executing it knows that he has locked everyone out of the database (but he can lock everyone out of the database if he wants to.) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings