[NOVICE] newbie problem on creating table

Does the database you created have the same name as the user executing the
query you mentioned? I believe that, as given, psql will try to connect
to a database having the same name as the login name of the user executing
the statement.

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Mon, 10 Jul 2000, Thomas Krebs wrote:

"Thomas Krebs" <thomas@krebs-haertl.de> writes:

It just returns "Error cannot create <tablename>.

I believe this error indicates that the kernel rejected Postgres'
attempt to create a file for the new table. Unfortunately we can't
see the exact kernel error message (that's fixed for 7.1, but it
won't help you for 7.0 unless you're prepared to alter and recompile
sources...).

I will make a wild guess that the problem is incorrect permissions on
the database directory. Take a look in $PGDATA/base/ and make sure the
database subdirectory is owned and writable by whatever user you are
running the postmaster as. (Which had better NOT be root!)

regards, tom lane

I am trying to get a start with Postgres 6.4 on Suse Linux 6.4.

I did that just 2 weeks ago.

and it works?

yes, no problems :
root@hanlrs:/tmp > su -- postgres
postgres@hanlrs:/tmp > PATH=$PATH:/usr/lib/pgsql/bin
postgres@hanlrs:/tmp > createuser
Enter name of user to add: root
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
postgres@hanlrs:/tmp > exit
root@hanlrs:/tmp > createuser nobody
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
root@hanlrs:/tmp > su -- nobody
nobody@hanlrs:/tmp > PATH=$PATH:/usr/lib/pgsql/bin
nobody@hanlrs:/tmp > createdb test
CREATE DATABASE
nobody@hanlrs:/tmp > psql -dtest -c "create table test1( a int)"
CREATE
nobody@hanlrs:/tmp > psql -dtest
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=> insert into test1 values (1);
INSERT 621408 1
test=> select * from test1
test-> \g
a
---
1
(1 row)

test=>

I deinstalled and installed postgres and executed exactly the same
statements as you, and it worked. One thing I am not sure about is during
creation of a user, I am asked whether to use a postgres ID or UNIX ID, what
is the right/recommended approach (I used UNIX ID).

Then I created a new database "castortest". I tried to execute a file
creating a schema with a bunch of tables and index definitions with
psql -dcastortest -f create.sql

This returned an error with the first create table statement. Any attempt
after that, even after reboot, to create a table failed.

Below is the postgresql.log file

-----

TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
Line: 446)

!(((bool) (UserId != 0))) (0) [Unpassender IOCTL (I/O-Control) f�r das
Ger�t]
ERROR: cannot create prod
ERROR: DefineIndex: prod relation not found
TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
Line: 446)

!(((bool) (UserId != 0))) (0) [Unpassender IOCTL (I/O-Control) f�r das
Ger�t]
ERROR: cannot create prod
TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
Line: 446)

!(((bool) (UserId != 0))) (0) [Unpassender IOCTL (I/O-Control) f�r das
Ger�t]
TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
Line: 446)

!(((bool) (UserId != 0))) (0) [Unpassender IOCTL (I/O-Control) f�r das
Ger�t]
ERROR: cannot create test2
ERROR: test2: Table does not exist.
TRAP: Failed Assertion("!(((bool) (UserId != 0))):", File: "miscinit.c",
Line: 446)

!(((bool) (UserId != 0))) (0) [Unpassender IOCTL (I/O-Control) f�r das
Ger�t]

"Thomas Krebs" <thomas@krebs-haertl.de> 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

Tom Lane wrote:

"Thomas Krebs" <thomas@krebs-haertl.de> 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

Tom Lane writes:

"Thomas Krebs" <thomas@krebs-haertl.de> 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
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

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