X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id B30C930F536 for ; Tue, 1 Jul 2003 00:39:01 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 10376-10 for ; Mon, 30 Jun 2003 21:38:50 -0300 (ADT) Received: from tomts10-srv.bellnexxia.net (tomts10.bellnexxia.net [209.226.175.54]) by svr1.postgresql.org (Postfix) with ESMTP id 0DF9B30E89C for ; Mon, 30 Jun 2003 21:38:50 -0300 (ADT) Received: from [192.168.1.200] ([216.209.81.133]) by tomts10-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030701003847.MSVD23576.tomts10-srv.bellnexxia.net@[192.168.1.200]>; Mon, 30 Jun 2003 20:38:47 -0400 Subject: Re: cleaning up useless pl/pgsql functions From: Rod Taylor To: Tomasz Myrta Cc: PGSQL-SQL In-Reply-To: <3F00A7F8.80107@klaster.net> References: <3F00A7F8.80107@klaster.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-+HWcLN/ERVs6LItWIJOO" Message-Id: <1057019945.28657.103.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 01 Jul 2003 00:39:06 +0000 X-Archive-Number: 200306/355 X-Sequence-Number: 14113 --=-+HWcLN/ERVs6LItWIJOO Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Mon, 2003-06-30 at 21:13, Tomasz Myrta wrote: > Hi > Do you have any easy script to remove all pl/pgsql function? After a lot = of=20 > changes inside "create or replace function..." scripts I have a big mess.= I=20 > want to remove all user defined pl/pgsql functions and restore some of th= em=20 > from my scripts again. DROP PROCEDURAL LANGUAGE plpgsql CASCADE; CREATE PROCEDURAL LANGUAGE plpgsql ... --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-+HWcLN/ERVs6LItWIJOO Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/ANgp6DETLow6vwwRApKTAJ9pNuhlEJIzIDudNxfiQ4hVjqeaegCeMTPd HD1Xn+8iDDVGEIWYguMoW0k= =2GOF -----END PGP SIGNATURE----- --=-+HWcLN/ERVs6LItWIJOO--