From: | "Thomas Krebs" <thomas(at)krebs-haertl(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | newbie problem on creating table |
Date: | 2000-07-10 13:01:19 |
Message-ID: | 011701bfea6e$f1174740$b240363e@sokrates |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
> HTH
> Holger Klawitter
> --
> Holger Klawitter +49 (0)251 484 0637
> holger(at)klawitter(dot)de http://www.klawitter.de/
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Travis Bauer | 2000-07-10 13:07:20 | Re: [NOVICE] newbie problem on creating table |
Previous Message | Thomas Krebs | 2000-07-10 12:59:54 | [NOVICE] newbie problem on creating table |