I tried the single-user mode option and it worked, thanks! but, don't you people think that we should provide this privilege in multi-user mode as well.In accordence to my second point.
On 2/24/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Freitag, 24. Februar 2006 14:25 schrieb Nauman Naeem: > > In case I have only one user in my database who is also the DBSystem > > (who carries out initdb), user then if that user takes away his > > "createuser" privileges, he is unable to grant himself that privilege > > again or grant that privilege to any other user that he creates.This > > creates quite a fix since you end up with no superusers, nor a way to > > create any other superusers. > > Shut down the server, start in single-user mode, then you can fix it. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match