Strange error

From: Mark Kettner <m(dot)kettner(at)elsevier(dot)nl>
To: owner-pgsql-general(at)hub(dot)org
Subject: Strange error
Date: 1999-02-01 13:00:31
Message-ID: 199902011300.OAA21799@olorin.elsevier.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm new to postgres. I started a project with msql, but the project
got bigger and bigger and I've reached the limits of msql, so I thought,
why not change to postgres.
Installing postgres went without any trouble (6.4.2 on a Solaris 2.5
machine). I exported all my tables made with msql and tried to import
them in postgres. However, when I tried to insert the following line
(with the \i option in psql)

INSERT INTO event VALUES (604,'174950','American Society of Critical Care Anesthesiologists 10th Annual Meeting',19971011,19940309,19971017,NULL,'','San Diego',7,2,2,76)\g

in this table:

CREATE TABLE event (
id int4,
event_id char(10),
title char(160),
modification_date int4,
input_date int4,
start_date int4,
end_date int4,
venue CHAR(30),
city CHAR(20),
state_id int4,
country_id int4,
region_id int4,
contact_id int4
) \g

CREATE UNIQUE INDEX Event0 ON Event (id) \g
CREATE UNIQUE INDEX Event1 ON Event (event_id) \g
CREATE INDEX Event2 ON Event (title) \g
CREATE INDEX Event3 ON Event (country_id) \g
CREATE INDEX Event4 ON Event (region_id) \g
CREATE INDEX Event5 ON Event (country_id) \g
CREATE INDEX Event6 ON Event (state_id) \g
CREATE INDEX Event7 ON Event (start_date) \g
CREATE INDEX Event8 ON Event (city) \g

psql crashes with the following error:

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.

I've dermined that that it doesn't like the place 'San Diego'. When changed
to 'Amsterdam' it's ok. Also the place 'Orlando' gives the same error.

Can anyone tell me why this error occurs? The other records (about 15.000)
don't give any problems. Does somebody else have the same errors?

Regards,

Mark Kettner

Browse pgsql-general by date

  From Date Subject
Next Message N. Thomas 1999-02-01 15:18:03 web interface for v.6.4.2
Previous Message Sebestyen Zoltan 1999-02-01 11:56:00 Anyone to compile PostgreSQL on 6.4.2?