Error creating tables.
От | Aristide Aragon |
---|---|
Тема | Error creating tables. |
Дата | |
Msg-id | 200010121723.KAA90363@lionking.org обсуждение исходный текст |
Ответы |
Re: Error creating tables.
Re: Error creating tables. |
Список | 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
В списке pgsql-general по дате отправления: