Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA18183; Fri, 5 Jul 91 07:06:46 -0700
Date: Fri, 5 Jul 91 07:06:46 -0700
Message-Id: <9107051406.AA18183@postgres.Berkeley.EDU>
From: postgres@jdsds1.ir.miami.edu (Raymond D. Frost)
Subject: postquel functions
To: postgres@postgres.berkeley.edu

I created the following postquel function:

     define postquel function hobbies(emp) returns hobbies is
     retrieve (hobbies.all) where hobbies.empname = emp.name

I tried to delete the function using:

     remove function hobbies

which returns an error message.

     Query sent to backend is "remove function hobbies "
     WARN:Jul  5 09:51:48:Remove: function hobbies nonexistant
 
yet hobbies_rule appears in the system catalog as a pg_rewrite rule.
Could you please tell me:

	1) how to delete the postquel function.
	2) what the difference is between an instance rule (pg_prs2rule)
	   and a rewrite rule (pg_rewrite).