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


Your name : Marek Mintal
Your email address : mintal@alert.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:
---------


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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJul 20, '99 at 9:42a
activeJul 20, '99 at 9:42a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Marek Mintal: 1 post

People

Translate

site design / logo © 2022 Grokbase