Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
This is a discussion on Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever within the pgsql Bugs forums, part of the PostgreSQL category; --> 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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 08:26 AM
| ||||
| ||||
 Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever 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      |
Linear Mode
