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
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
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
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 +
Hi,
I just downloaded a fresh distribution of postgresql-8.0.0beta3 and tried
compiling it on a Mac OS X 10.3.5 (Panther -- fresh install), and it gave me
the following error:
sledge:~/tmp/postgresql-8.0.0beta3 sfg900$ ./configure
--prefix=/opt/postgresql-8.0.0beta3 --with-python --with-openssl -
