Return-Path: steve@web.com 
Delivery-Date: Wed, 08 Sep 93 14:41:21 PDT
Return-Path: steve@web.com
Received: from uu2.psi.com by postgres.Berkeley.EDU (5.61/1.29)
	id AA15296; Wed, 8 Sep 93 14:41:19 -0700
Received: by uu2.psi.com (5.65b/4.0.071791-PSI/PSINet) via UUCP;
	id AA04493 for ; Wed, 8 Sep 93 17:47:56 -0400
Date: Wed, 8 Sep 93 17:11:56 EDT
From: steve@web.com (Steve Bond)
Received: from quark.web.com (quark.ARPA) by web.com (4.1/3.2.083191-WEB Development Corp.)
	id AA03053; Wed, 8 Sep 93 17:11:56 EDT
Message-Id: <9309082111.AA03053@web.com>
To: aoki@postgres.Berkeley.EDU
Subject: The exact code which hangs


Here is the exact code which hangs:


#! /bin/csh -f
 
#goto start
destroydb web
createdb web
 
monitor web << EOF
 
create x (a = int2)\g
append x (a = 1)\g
 
EOF
 
start:
 
monitor web << EOF
 
retrieve (x.all)\g
 
\q
EOF
goto start



This gives me output Welcome to the C POSTGRES terminal monitor
 
Go 
* 
Query sent to backend is "create x (a = int2)"
CREATE
Go 
* 
Query sent to backend is "append x (a = 1)"
APPEND 1036907
Go 
* I live to serve you.
Welcome to the C POSTGRES terminal monitor
 
Go 
* 
Query sent to backend is "retrieve (x.all)"
---------------
| a           |
---------------
| 1           |
---------------