Outch,

just got the following on the 6.4b2:

pgsql=> create table t1 (a int4, b date);
CREATE
pgsql=> insert into t1 values (1, 'now');
INSERT 18282 1
pgsql=> update t1 set b = NULL where a = 1;
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible.  Terminating.


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #


Sun, 18 Oct 1998 23:13:49 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Crashing backend!
jwieck@debis.com (Jan Wieck) writes:
> just got the following on the 6.4b2:
> pgsql=> create table t1 (a int4, b date);
> CREATE
> pgsql=> insert into t1 values (1, 'now');
> INSERT 18282 1
> pgsql=> update t1 set b = NULL where a = 1;
> pqReadData() -- backend closed the channel unexpectedly.

FWIW, that sequence works fine for me here, using current CVS sources.
Perhaps it's platform-dependent?  (I'm on HPUX.)  Or maybe a bug fixed
since the 6.4b2 tarball?

			regards, tom lane

Sun, 18 Oct 1998 19:39:22 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Crashing backend! 
> Outch,
> 
> just got the following on the 6.4b2:
> 
> pgsql=> create table t1 (a int4, b date);
> CREATE
> pgsql=> insert into t1 values (1, 'now');
> INSERT 18282 1
> pgsql=> update t1 set b = NULL where a = 1;
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.  Terminating.

Just tested it on BSDI.  Worked fine.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 19 Oct 1998 01:49:12 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Crashing backend!
Jan Wieck wrote:
> Outch,
> 
> just got the following on the 6.4b2:
> 
> pgsql=> create table t1 (a int4, b date);
> CREATE
> pgsql=> insert into t1 values (1, 'now');
> INSERT 18282 1
> pgsql=> update t1 set b = NULL where a = 1;
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.  Terminating.

I just tested it on the UnixWare 7.x port and it worked fine.
-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    | 



Mon, 19 Oct 1998 02:16:56 -0400
"Billy G. Allie" <Bill.Allie@mug.org>
Re: [HACKERS] Crashing backend! 
>
> Outch,
>
> just got the following on the 6.4b2:
>
> pgsql=> create table t1 (a int4, b date);
> CREATE
> pgsql=> insert into t1 values (1, 'now');
> INSERT 18282 1
> pgsql=> update t1 set b = NULL where a = 1;
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible.  Terminating.

    Seems  something  is  spying  my email here on the system. As
    soon as you all reported that it works for  you  the  problem
    disappeared.

    Sorry for the panic.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Mon, 19 Oct 1998 12:07:38 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] Crashing backend!