newbie problem on creating table

Started by Thomas Krebsalmost 26 years ago3 messagesgeneral
Jump to latest
#1Thomas Krebs
thomas@krebs-haertl.de

I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. I created a
superuser who is allowed to create databases. I created a user and a
database, but I didn't manage so far to create a table. It just returns
"Error cannot create <tablename>.
In the configuration file for the authentication, I used the settings coming
with the installation:

local all trust
hosts all 127.0.0.1 255.255.255.255 trust

The logfile also just shows the messages:
Error: Cannot create <table>
AbortCurrentTx
....

I am really stuck and have no glue where to look or to start. Any help is
highly welcome

thomas

PS: posted to pgsql-novice and pgsql-general

#2ChristophSchmidt
cs.hilzingen@swol.de
In reply to: Thomas Krebs (#1)
Re: newbie problem on creating table

Are you able to show the systemtables from psql prompt ?
What looks your create table statement like ?
As which user did you create the database and as who you are
logged in (System/database) ?

cs

Show quoted text

I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. I created a
superuser who is allowed to create databases. I created a user and a
database, but I didn't manage so far to create a table. It just returns
"Error cannot create <tablename>.
In the configuration file for the authentication, I used the settings coming
with the installation:

local all trust
hosts all 127.0.0.1 255.255.255.255 trust

The logfile also just shows the messages:
Error: Cannot create <table>
AbortCurrentTx
....

I am really stuck and have no glue where to look or to start. Any help is
highly welcome

thomas

PS: posted to pgsql-novice and pgsql-general

#3Thomas Krebs
thomas@krebs-haertl.de
In reply to: Thomas Krebs (#1)
Re: [GENERAL] newbie problem on creating table

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

created a

superuser who is allowed to create databases. I created a user and a
database, but I didn't manage so far to create a table. It just returns
"Error cannot create <tablename>.

The owner of your database might the postgres superuser. You will have
to set the permissions or the owner accordingly. The latter can be
done in 7.0.x as superuser with:

UPDATE pg_database
SET datdba=<uid of new user>
WHERE datname=<name of db in question>
;

I checked pg_database: The datadba for the database is root and I am
accessing the database as root.
any other ideas?

Show quoted text

HTH
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger@klawitter.de http://www.klawitter.de/