Port Bug Report: connection to the backend is lost while using a rule

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgreSQL(dot)org
Subject: Port Bug Report: connection to the backend is lost while using a rule
Date: 1999-07-20 09:58:14
Message-ID: 199907200958.FAA09173@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Marek Mintal
Your email address : mintal(at)alert(dot)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:
---------

--------------------------------------------------------------------------

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message Esteban Chiner Sanz 1999-07-20 12:08:36 PostgreSQL 6.5 on Solaris 2.6
Previous Message Unprivileged user 1999-07-20 09:53:36 Port Bug Report: Running 'gmake all' gives Error 1 and Error 2 messages