Thread: Port Bug Report: connection to the backend is lost while using a rule
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Marek Mintal
Your email address : mintal@alert.sk
Category : runtime: back-end: SQL
Severity : serious
Summary: connection to the backend is lost while using a rule
System Configuration
--------------------
Operating System : linux 2.0.36 ELF
PostgreSQL version : 6.4.2, 6.5
Compiler used : gcc 2.7.2.3
Hardware:
---------
Linux main.ews.sk 2.0.36 #7 Mon Apr 26 15:25:25 CEST 1999 i686 unknown
Versions of other tools:
------------------------
gmake 3.76.1
flex 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
example:create table c (inout int4);
create table l (totalin int4, totalout int4);
insert into l values(0,0);
create rule c_in as on insert to c where new.inout > 0 do instead update l set totalin=new.inout;
insert into c values(1);
insert into c values(-1);
result:
--------------------------------------------------------------------------
Test Case:
----------
pqReadData() -- backend closed the channel unexpectedly.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
Re: [PORTS] Port Bug Report: connection to the backend is lost while using a rule
From
Bruce Momjian
Date:
Sorry, I can not reproduce this error. > > ============================================================================ > POSTGRESQL BUG REPORT TEMPLATE > ============================================================================ > > > Your name : Marek Mintal > Your email address : mintal@alert.sk > > Category : runtime: back-end: SQL > Severity : serious > > Summary: connection to the backend is lost while using a rule > > System Configuration > -------------------- > Operating System : linux 2.0.36 ELF > > PostgreSQL version : 6.4.2, 6.5 > > Compiler used : gcc 2.7.2.3 > > Hardware: > --------- > Linux main.ews.sk 2.0.36 #7 Mon Apr 26 15:25:25 CEST 1999 i686 unknown > > Versions of other tools: > ------------------------ > gmake 3.76.1 > flex 2.5.4 > > -------------------------------------------------------------------------- > > Problem Description: > -------------------- > example:create table c (inout int4); > create table l (totalin int4, totalout int4); > insert into l values(0,0); > > create rule c_in as on insert to c where new.inout > 0 do instead update l set totalin=new.inout; > insert into c values(1); > insert into c values(-1); > > result: > > > > > -------------------------------------------------------------------------- > > Test Case: > ---------- > pqReadData() -- backend closed the channel unexpectedly. > > -------------------------------------------------------------------------- > > Solution: > --------- > > > -------------------------------------------------------------------------- > > > -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Re: [PORTS] Port Bug Report: connection to the backend is lost whileusing a rule
From
Marek Mintal
Date:
Bruce Momjian wrote: > Sorry, I can not reproduce this error. The problem was, that I had not the latest postgres version ... my 6.5 was only beta. Now everything works correctly .. Thanx for Your time ... > > > > > ============================================================================ > > POSTGRESQL BUG REPORT TEMPLATE > > ============================================================================ > > > > > > Your name : Marek Mintal > > Your email address : mintal@alert.sk > > > > Category : runtime: back-end: SQL > > Severity : serious > > > > Summary: connection to the backend is lost while using a rule > > > > System Configuration > > -------------------- > > Operating System : linux 2.0.36 ELF > > > > PostgreSQL version : 6.4.2, 6.5 > > > > Compiler used : gcc 2.7.2.3 > > > > Hardware: > > --------- > > Linux main.ews.sk 2.0.36 #7 Mon Apr 26 15:25:25 CEST 1999 i686 unknown > > > > Versions of other tools: > > ------------------------ > > gmake 3.76.1 > > flex 2.5.4 > > > > -------------------------------------------------------------------------- > > > > Problem Description: > > -------------------- > > example:create table c (inout int4); > > create table l (totalin int4, totalout int4); > > insert into l values(0,0); > > > > create rule c_in as on insert to c where new.inout > 0 do instead update l set totalin=new.inout; > > insert into c values(1); > > insert into c values(-1); > > > > result: > > > > > > > > > > -------------------------------------------------------------------------- > > > > Test Case: > > ---------- > > pqReadData() -- backend closed the channel unexpectedly. > > > > -------------------------------------------------------------------------- > > > > Solution: > > --------- > > > > > > -------------------------------------------------------------------------- > > > > > > > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Marek Mintal <mintal@alert.sk>