[BUGS] BUG #3305: multiple Operator classes

The following bug has been logged online: Bug reference: 3305 Logged by: Belykh Oleg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: MAC OS X Description:multiple Operator classes Details: Index scan use only default operator class anyway,

[BUGS] BUG #3307: Software error when accessed

The following bug has been logged online: Bug reference: 3307 Logged by: ann Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: linux(Fedora) Description:Software error when accessed Details: im not able to access the server. when accessed it

Re: [BUGS] BUG #3305: multiple Operator classes

"Belykh Oleg" <[EMAIL PROTECTED]> writes: > Index scan use only default operator class anyway, but there is 2 defined > operator classes. Perhaps you forgot to make an index using the nondefault opclass? regards, tom lane ---(end of broadcast)-

Re: [BUGS] BUG #3307: Software error when accessed

"ann" <[EMAIL PROTECTED]> writes: > Can't load '/usr/local/lib/perl5/5.6.2/i686-linux/auto/IO/IO.so' for module > IO: /usr/local/lib/perl5/5.6.2/i686-linux/auto/IO/IO.so: failed to map > segment from shared object: Permission denied at > /usr/local/lib/perl5/5.6.2/i686-linux/XSLoader.pm line 75. T

[BUGS] BUG #3308: Nested outer join gives wrong results

The following bug has been logged online: Bug reference: 3308 Logged by: George Sakkis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Linux Description:Nested outer join gives wrong results Details: I have the following two subqueries,

Re: [BUGS] BUG #3308: Nested outer join gives wrong results

"George Sakkis" <[EMAIL PROTECTED]> writes: > SELECT * > FROM ( > SELECT query.id as q_id > FROM ranker, run, query > WHERE ranker.id = 72 AND > run.id = ranker.run_id AND > query.set_id = run.set_id > ) AS t1 > LEFT JOIN ( > SELECT serp_result.q_id > FROM serp_result LE