Port Bug Report: lost connection to the backend while using a rule
От | Unprivileged user |
---|---|
Тема | Port Bug Report: lost connection to the backend while using a rule |
Дата | |
Msg-id | 199907200942.FAA06477@hub.org обсуждение исходный текст |
Список | pgsql-ports |
============================================================================ 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: --------- --------------------------------------------------------------------------
В списке pgsql-ports по дате отправления: