On 15/1/05 9:55 AM, "Fahad G." <Fahad.Gilani@anusf.anu.edu.au> wrote:
.....
> -- Grants
> REVOKE ALL ON TABLE jobstat_lc_q3_2004 FROM PUBLIC;
> GRANT SELECT ON TABLE jobstat_lc_q3_2004 TO apache;
....

Sorry about that, I pasted the wrong 'grants' from the log. This should be
...._q4_... Where it says q3.

Also, the following 'fails' as well:

hpc=> SELECT jobid, curr_walltime, status, fetchtime FROM jobstat_lc_q4_2004
WHERE jobid = 123123 ORDER BY fetchtime DESC LIMIT 1;

Or

hpc=> SELECT * FROM jobstat_lc_q4_2004 WHERE jobid = 123123 ORDER BY
fetchtime DESC LIMIT 1;

Cheers,
Fahad



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org