Re: Re: [NOVICE] newbie problem on creating table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Thomas Krebs <thomas(at)krebs-haertl(dot)de>, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: [NOVICE] newbie problem on creating table
Date: 2000-07-12 23:08:23
Message-ID: 25304.963443303@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-07-12 23:25:35 Re: sql question
Previous Message Peter Eisentraut 2000-07-12 22:54:58 Re: Re: [NOVICE] newbie problem on creating table

Browse pgsql-novice by date

  From Date Subject
Next Message Christopher Smith 2000-07-12 23:27:53 using pg_fieldisnull
Previous Message Peter Eisentraut 2000-07-12 22:54:58 Re: Re: [NOVICE] newbie problem on creating table