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
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 |