Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group