Skip site navigation (1) Skip section navigation (2)

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

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgreSQL(dot)org
Subject: Port Bug Report: lost connection to the backend while using a rule
Date: 1999-07-20 09:42:55
Message-ID: 199907200942.FAA06477@hub.org (view raw or flat)
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: lost connection to the backend while using a rule

System Configuration
--------------------
  Operating System   : linux 2.0.36 ELF

  PostgreSQL version : 6.4.2

  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

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

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);

result:
pqReadData() -- backend closed the channel unexpectedly.



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

Test Case:
----------
it crashed everytime using:

insert into c values(-1);

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

Solution:
---------


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


pgsql-ports by date

Next:From: Unprivileged userDate: 1999-07-20 09:53:36
Subject: Port Bug Report: Running 'gmake all' gives Error 1 and Error 2 messages
Previous:From: Thomas LockhartDate: 1999-07-20 05:10:59
Subject: Re: [PORTS] RedHat6.0 & Alpha

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group