Re: Is there a command like uf_purge

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Peter Dawn <petedawn(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a command like uf_purge
Date: 2006-07-03 13:41:09
Message-ID: 20060703134108.GA3727@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]

On Mon, Jul 03, 2006 at 01:20:53PM +1000, Peter Dawn wrote:
> i executed this query (SELECT uf_purge(365)) within PGAdmin and the
> query executed successfully (the output was row1 uf_urge(bool) t.
> but i dont know what exactly i did. i think that it might have purged
> the data for these many days? dont know for sure though.

I don't see any instances of "uf_purge" in the pgAdmin III source
code either, so it doesn't appear to belong to that package. How
did you find out about this function and why are you executing it
if you're not sure what it does? What's the output of the following
command?

SELECT * FROM pg_proc WHERE proname = 'uf_purge';

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2006-07-03 13:47:57 Re: Optimizing query: select ... where id = 4 and md5(...) = '...'
Previous Message A. Kretschmer 2006-07-03 13:39:19 Re: php can't connect to postgresql server