Skip site navigation (1) Skip section navigation (2)

Re: [PORTS] Port Bug Report: connection to the backend is lost whileusing a rule

From: Marek Mintal <mintal(at)alert(dot)sk>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: connection to the backend is lost whileusing a rule
Date: 1999-09-24 07:13:51
Message-ID: 37EB24AF.3390391@alert.sk (view raw or flat)
Thread:
Lists: pgsql-ports
Bruce Momjian wrote:

> Sorry, I can not reproduce this error.

The problem was, that I had not the latest postgres version ... my 6.5 was only beta.
Now everything works correctly ..

Thanx for Your time ...

>
> >
> > ============================================================================
> >                         POSTGRESQL BUG REPORT TEMPLATE
> > ============================================================================
> >
> >
> > Your name               : Marek Mintal
> > Your email address      : mintal(at)alert(dot)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:
> > ---------
> >
> >
> > --------------------------------------------------------------------------
> >
> >
> >
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Marek Mintal
<mintal(at)alert(dot)sk>


In response to

pgsql-ports by date

Next:From: Ted Nolan SRI Augusta GADate: 1999-09-24 15:22:35
Subject: ipc-daemon runs wild on NT?
Previous:From: Tom LaneDate: 1999-09-24 00:31:47
Subject: Re: [HACKERS] Re: [PORTS] RedHat6.0 & Alpha

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group