From: | Együd Csaba <csegyud(at)freemail(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | drop function all - ? |
Date: | 2003-07-13 12:02:15 |
Message-ID: | 004501c34936$9cdd3430$230a0a0a@compaq |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
is there any way to get rid of all of my functions in a database. I mean
such an expression: DROP FUNCTION ALL;
The point of this issue is that time to time one writes and rewrites
functions with the same name and forgets to remove the existing ones. At a
certain time one tries to call a function but don't know why it fails. It
fails bacause there is an other (or more) function with the same name and
with a very similar parameter list (the same number and convertable types).
I'm in this situation....
So I'd like to remove all my functions and recreate the latest ones from a
file. Without dropping the whole database of corse.
Any suggestions????
Thank you,
-- Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.495 / Virus Database: 294 - Release Date: 2003. 06. 30.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-07-13 13:00:05 | Re: Is SQL silly as an RDBMS<->app interface? |
Previous Message | Jan Wieck | 2003-07-13 11:38:41 | Re: Is SQL silly as an RDBMS<->app interface? |