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