Horton

Thread

  1. sql rules bug

    Marek Mintal <mintal@alert.sk> — 1999-07-20T10:01:10Z

    If I didn't understant a system of sending a bugs, sorry if you get this
message twice or more.

============================================================================

                        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:
---------


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

Marek Mintal
<mintal@alert.sk>