Error creating tables.

From: Aristide Aragon <aristide(at)lionking(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Error creating tables.
Date: 2000-10-12 17:23:18
Message-ID: 200010121723.KAA90363@lionking.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello
I am new to this list, mostly because I just started using (or trying to) postgreSQL.
I tried to create a table using the example at www.freebsddiary.org/postgresql.html and also at http://www.postgresql.org/users-lounge/docs/7.0/tutorial/query1356.htm . None works.
Tracing down what could be wrong, I came to the conclusion that I can't create any table containing a varchar().
The statement:
create table test4 (name varchar(10)) ;
returns
ERROR: cannot create test4

however, the statement
create table test (id serial, name varchar(10) ) ;
returns:
NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for SERIAL column 'test.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'test_id_key' for table 'test'
ERROR: cannot create test_id_seq

But just the statement
create table test3 (id serial) ;
succeedes.

Any ideas?

my system is a K6-2 PC running SuSE Linux 6.3, postgress was installed from the SuSE CDs, not from the sources.
My version of postgresql is 6.5.1

Other error that may be related is that sometimes instead of the error messages I gave (or instead of any return message), psql aborts saying:
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

Any advice is welcome.
Aristide

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bmccoy 2000-10-12 17:25:48 Re: automatic insert of next sequence value?
Previous Message Alfred Perlstein 2000-10-12 17:22:10 Re: automatic insert of next sequence value?