Re: Re: [NOVICE] newbie problem on creating table - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: [NOVICE] newbie problem on creating table
Date
Msg-id 25304.963443303@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: [NOVICE] newbie problem on creating table  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
>>>> TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
>>>> Line: 446)
>>
>> I think what's causing this is that you can't use zero as a Postgres
>> userid.  Unfortunately createuser doesn't enforce that restriction;
>> I'll see about fixing that oversight for 7.1.

> Create User does, but initdb doesn't.

Hmm.  But we have other defenses against the postgres superuser being
root.  I had assumed that the issue here was a non-superuser Postgres
account being created with zero userid...

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: [NOVICE] newbie problem on creating table
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: sql question