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,'','SanDiego',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