The following bug has been logged online:
Bug reference: 1393
Logged by: Fahad
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0rc2
Operating system: Linux
Description:Adding 'LIMIT 1' to the query halts forever if no data
present
Details:
Hi,
I
than
reporting an error.
Moreover, there's no 'gmake' in Mac OS X, and it uses 'make' instead. The
installation guide should mention this as well.
Cheers,
Fahad
--
main(){int j=12345;char t[]=":aAbcdefFgGhijklmnNopqrsStuUvwyz \n",
*i="dUGScUiAbpmwqbmgduAv
ly. I've
attached the log from pg_lock, as you requested, as well when I ran the
above query. Hope something can be sorted out.
Thanks for your time.
Regards,
Fahad
On 15/1/05 5:18 AM, "Michael Fuhr" <[EMAIL PROTECTED]> wrote:
> On Fri, Jan 14, 2005 at 10:47:52PM +
On 15/1/05 9:55 AM, "Fahad G." <[EMAIL PROTECTED]> 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 sh
Michael,
On 16/1/05 12:48 AM, "Michael Fuhr" <[EMAIL PROTECTED]> wrote:
> On Fri, Jan 14, 2005 at 11:31:05PM -0500, Tom Lane wrote:
>> "Fahad G." <[EMAIL PROTECTED]> writes:
>>> -- Indexes
>>> CREATE INDEX jobstat_lc_q4_2004_jobid ON j
to fix this problem? I don't see why adding LIMIT 1 should
choose the wrong index. Thanks,
Fahad
On 15/1/05 3:31 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> "Fahad G." <[EMAIL PROTECTED]> writes:
>> -- Indexes
>> CREATE INDEX jobstat_lc_q
