Re: [HACKERS] trouble with rules
Vadim Mikheev <vadim@krs.ru>
From: Vadim Mikheev <vadim@krs.ru>
To: Jan Wieck <jwieck@debis.com>
Cc: Erich Stamberger <eberger@gewi.kfunigraz.ac.at>, pgsql-hackers@postgreSQL.org
Date: 1999-02-02T10:13:40Z
Lists: pgsql-hackers
Jan Wieck wrote: > > > > > Hi! > > > > can somebody see this too? > > > > create table t1(i1 int4); > > create table t2(i1 int4); > > create table t3(i2 int4); > > > > test=> create rule rm_t1 as on delete to t1 > > test-> do ( delete from t2 where old.i1 = i1; > > test-> delete from t3 where old.i1 = i2;); > > 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. > > > > > > OS = Linux 2.0.35, gcc 2.7.2.3, postgreSQL-6.4.2 > > That's courios. I can't reproduce it with v6.4 or v6.4.2 > (Linux 2.1.88, gcc 2.7.2.1). Did the checks with the release > tarballs, not with the REL_6_4 tree (will check that later). CASSERT is off? Vadim