sql rules bug
От | Marek Mintal |
---|---|
Тема | sql rules bug |
Дата | |
Msg-id | 379448E6.CE6503A2@alert.sk обсуждение исходный текст |
Список | pgsql-bugs |
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>
В списке pgsql-bugs по дате отправления: