Version 7.2.1, RH 7.3, installed from RPM. Following error occurs:
amber_ws=> delete from samples; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> The table looks like this: CREATE TABLE "samples" ( "id" integer DEFAULT nextval('"samples_id_seq"'::varchar(32)), "fieldtrip_in" integer REFERENCES "fieldtrips" ON DELETE RESTRICT ON UPDATE CASCADE, "fieldtrip_out" integer REFERENCES "fieldtrips" ON DELETE RESTRICT ON UPDATE CASCADE, "site_name" varchar(32) REFERENCES "sites" ON DELETE RESTRICT ON UPDATE CASCADE, "collector_type" varchar(32) REFERENCES "collector_types" ON DELETE RESTRICT ON UPDATE CASCADE, "depth" varchar(32) REFERENCES "depth_types" ON DELETE RESTRICT ON UPDATE CASCADE, "replicate" varchar(32) REFERENCES "replicate_set" ON DELETE RESTRICT ON UPDATE CASCADE, "lost_bool" boolean default false, "buoy" varchar(32), "comments" varchar(32), Constraint "samples_pkey" Primary Key ("id") ); The single record in it looks like this: amber_ws=> select * from samples; -[ RECORD 1 ]--+-- id | 1 fieldtrip_in | 1 fieldtrip_out | 1 site_name | collector_type | depth | replicate | lost_bool | f buoy | comments | No tables are using it as a REFERENCES target. Let me know if I can help more. I am not root on the box, so I am not going to try attaching gdb to anything tonight. However, the root user and I would be quite happy to do so later. Thanks Webb ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly