Re: PgAdmin question - superuser - Mailing list pgsql-general

From A_Schnabel@t-online.de (Andre Schnabel)
Subject Re: PgAdmin question - superuser
Date
Msg-id 005301c132b0$caef5540$0201a8c0@aschnabel.homeip.net
Whole thread Raw
In response to PgAdmin question - superuser  ("Susan Lane" <suel@dpn.com>)
List pgsql-general
----- Original Message -----
From: "Susan Lane" <suel@dpn.com>
Subject: [GENERAL] PgAdmin question - superuser


> Hi -
>
> I set up a user and database using psql.  Then when I added the DSN
> connection for PgAdmin and tried it out with my new user id, it told me I
> had to log in as superuser.  So, I did.  Then I disconnected and logged in
> again as the new user I had created.  The second time, it worked.  Anybody
> know what happens behind the scenes that makes you log in as superuser the
> first time?  Is there some kind of initialization going on?

Yes PgAdmin builds some tables to it's own use. Therefore you have to be
superuser whe connecting the first time.





pgsql-general by date:

Previous
From: Daniel Kalchev
Date:
Subject: Re: [WAY OT] Re: PL/java?
Next
From: bj@zuto.de (Rainer Clasen)
Date:
Subject: select a random record