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>.
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
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 trustThe 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 welcomethomas
PS: posted to pgsql-novice and pgsql-general
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/