Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA26136; Mon, 14 Sep 92 15:09:26 -0700
Date: Mon, 14 Sep 92 15:09:26 -0700
Message-Id: <9209142209.AA26136@postgres.Berkeley.EDU>
From: neve@nlm.nih.gov (Leif Neve)
Subject: Renaming Attributes Doesn't Work
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

The postquel RENAME command doesn't seem to work completely:

---------------------------------------------------------------
% monitor db < test.pq

Welcome to the C POSTGRES terminal monitor
 
Go 
* 
Query sent to backend is "create foobar (foo=int2) "
CREATE
Go 
* 
Query sent to backend is "append foobar (foo=3) "
APPEND 23787
Go 
* 
Query sent to backend is "retrieve (foobar.all) "
---------------
| foo         |
---------------
| 3           |
---------------
 
Go 
* 
Query sent to backend is "rename foo in foobar to newfoo "
RENAME
Go 
* 
Query sent to backend is "retrieve (foobar.all) "
---------------
| newfoo      |
---------------
| 3           |
---------------
 
Go 
* 
Query sent to backend is "retrieve (foobar.newfoo) "
WARN:Sep 14 18:02:16:no such attribute or function newfoo
-----------------------------------------------------------------

What am I doing wrong?

Leif Neve