Re: newbie problem on creating table

From: ChristophSchmidt <cs(dot)hilzingen(at)swol(dot)de>
To: "Thomas Krebs" <thomas(at)krebs-haertl(dot)de>, pgsql-novice(at)postgresql(dot)org
Subject: Re: newbie problem on creating table
Date: 2000-07-06 06:37:09
Message-ID: 00070608402100.00417@nasen2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2000-07-06 07:21:13 Re: function for date difference ?
Previous Message Ferruccio Zamuner 2000-07-06 06:05:11 Partial indices

Browse pgsql-novice by date

  From Date Subject
Next Message Ami Ganguli 2000-07-06 12:48:41 UPDATING and DELETING sub-classes
Previous Message Thomas Krebs 2000-07-05 18:26:27 newbie problem on creating table