Re: PostgreSQL error (Segmentation Fault with message "SSL SYSCALL error: EOF detected") - Mailing list pgsql-bugs

angell2006@ukr.net writes:
> If I execute queries:

> DROP TABLE IF EXISTS client_tt;
> CREATE TABLE client_tt(id_client_tt integer NOT NULL, id_unique integer);
> INSERT INTO client_tt(id_client_tt, id_unique) VALUES('1', '1');
> ALTER TABLE ONLY client_tt ADD CONSTRAINT client_tt_pkey PRIMARY KEY (id_client_tt);
> ALTER TABLE ONLY client_tt ADD CONSTRAINT client_tt_ibfk_7 FOREIGN KEY (id_unique) REFERENCES client_tt(id_client_tt)
ONDELETE SET NULL DEFERRABLE; 
> ALTER TABLE client_tt ADD COLUMN tt_code_inn VARCHAR(12) NOT NULL DEFAULT '';
> DELETE FROM client_tt;

This looks like a known bug that's fixed in 11.1, released yesterday.

            regards, tom lane