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

2000-07-12 Thread Tom Lane 

"Thomas Krebs" [EMAIL PROTECTED] 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.

regards, tom lane

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

2000-07-12 Thread root 

Tom Lane wrote:
 
 "Thomas Krebs" [EMAIL PROTECTED] 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.
 
 regards, tom lane

Sorry, but I'm think you are wrong.
I run Postgres (7.0.2) without any problems as userid 0.

pg_id says:

"root pg_id
uid=0(root)"

Andreas Maus

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

2000-07-12 Thread Peter Eisentraut 

Tom Lane writes:

 "Thomas Krebs" [EMAIL PROTECTED] 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.


-- 
Peter Eisentraut  Sernanders väg 10:115
[EMAIL PROTECTED]   75262 Uppsala
http://yi.org/peter-e/Sweden

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

2000-07-12 Thread Tom Lane 

Peter Eisentraut [EMAIL PROTECTED] 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