Re: PgAdmin question - superuser

From: A_Schnabel(at)t-online(dot)de (Andre Schnabel)
To: "Susan Lane" <suel(at)dpn(dot)com>, "ML: Postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PgAdmin question - superuser
Date: 2001-09-01 06:39:03
Message-ID: 005301c132b0$caef5540$0201a8c0@aschnabel.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
From: "Susan Lane" <suel(at)dpn(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rainer Clasen 2001-09-01 06:57:50 select a random record
Previous Message Daniel Kalchev 2001-09-01 06:25:11 Re: [WAY OT] Re: PL/java?