Re: Curious case of the unstoppable user

On 29 March 2011 21:51, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On 03/29/2011 01:32 PM, Thom Brown wrote:
>>
>> On 29 March 2011 21:28, hubert depesz lubaczewski<depesz@depesz.com>
>>  wrote:
>>>
>>> On Tue, Mar 29, 2011 at 07:44:51PM +0100, Thom Brown wrote:
>>>>
>>>> So, I'm overlooking something.  Could someone tell me what it is?  I
>>>> bet it's something obvious.  I'm using 9.1dev if it's relevant.
>>>
>>> perhaps meow is superuser?
>>
>> stuff=>  \dg+
>>                                     List of roles
>>  Role name |                   Attributes                   | Member
>> of | Description
>>
>> -----------+------------------------------------------------+-----------+-------------
>>  meow      |                                                | {}        |
>>  testrole  | Cannot login                                   | {}        |
>>  thom      | Superuser, Create role, Create DB, Replication | {}        |
>>
>
> My guess is you have pg_hba.conf set up to use trust for the connection. In
> your original example testrole failed because it is not a login role not for
> permissions reasons. When \c to stuff as meow can you do \d?

I can do \d, but it doesn't show anything since there's nothing in
there.  But it does let me create a table, then see it using \d...

stuff=> \c stuff meow
You are now connected to database "stuff" as user "meow".
stuff=> \d
No relations found.
stuff=> create table test (id serial);
NOTICE:  CREATE TABLE will create implicit sequence "test_id_seq" for
serial column "test.id"
CREATE TABLE
stuff=> \d
            List of relations
 Schema |    Name     |   Type   | Owner
--------+-------------+----------+-------
 public | test        | table    | meow
 public | test_id_seq | sequence | meow
(2 rows)

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company