Re: PostgreSQL error (Segmentation Fault with message "SSL SYSCALL error: EOF detected")

angell2006(at)ukr(dot)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) ON DELETE 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