From: | "Thomas Krebs" <thomas(at)krebs-haertl(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: [NOVICE] newbie problem on creating table |
Date: | 2000-07-12 08:07:45 |
Message-ID: | 001801bfebd8$53b99dc0$4942363e@sokrates |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
> >> >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(at)hanlrs:/tmp > su -- postgres
> postgres(at)hanlrs:/tmp > PATH=$PATH:/usr/lib/pgsql/bin
> postgres(at)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(at)hanlrs:/tmp > exit
> root(at)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(at)hanlrs:/tmp > su -- nobody
> nobody(at)hanlrs:/tmp > PATH=$PATH:/usr/lib/pgsql/bin
> nobody(at)hanlrs:/tmp > createdb test
> CREATE DATABASE
> nobody(at)hanlrs:/tmp > psql -dtest -c "create table test1( a int)"
> CREATE
> nobody(at)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]
> --
> Bernd Tegge mailto:tegge(at)repas-aeg(dot)de
> Tel: ++49-511-87449-12 repas AEG Automation GmbH
> Fax: ++49-511-87449-20 GS Hannover, Germany
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Tille | 2000-07-12 08:16:49 | Migrating from MS SQL server |
Previous Message | Tom Lane | 2000-07-12 07:53:37 | Re: psql and Gnu readline |
From | Date | Subject | |
---|---|---|---|
Next Message | ChristophSchmidt | 2000-07-12 09:40:46 | Re: Adding params to postmaster.opts file |
Previous Message | Antony Stace | 2000-07-12 07:43:37 | how do I process data with a perl/cgi script & deliver result back to user via php |