On 15/1/05 9:55 AM, "Fahad G." <Fahad(dot)Gilani(at)anusf(dot)anu(dot)edu(dot)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