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 по дате отправления: