[BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Peter Much
The following bug has been logged online: Bug reference: 4932 Logged by: Peter Much Email address: p...@citylink.dinoex.sub.org PostgreSQL version: 8.4.0 Operating system: FreeBSD 7.2 Description:Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing Details: In chapter

Re: [BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Magnus Hagander
On Wed, Jul 22, 2009 at 11:42, Peter Much wrote: > > The following bug has been logged online: > > Bug reference:      4932 > Logged by:          Peter Much > Email address:      ...@citylink.dinoex.sub.org > PostgreSQL version: 8.4.0 > Operating system:   FreeBSD 7.2 > Description:        Upgrade

[BUGS] BUG #4933: ts_rewrite() causes segfault when query with more than one node becomes empty

2009-07-22 Thread Aaron Marcuse-Kubitza
The following bug has been logged online: Bug reference: 4933 Logged by: Aaron Marcuse-Kubitza Email address: aaro...@blackducksoftware.com PostgreSQL version: 8.3.7 Operating system: Mac OS X 10.5.7 Description:ts_rewrite() causes segfault when query with more than o

Re: [BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Peter Much
Dear Magnus! On Wed, Jul 22, 2009 at 11:52:32AM +0200, Magnus Hagander wrote: ! On Wed, Jul 22, 2009 at 11:42, Peter Much wrote: ! > In chapter 19.3.5 of the manual an option "krb_server_hostname" is ! > mentioned. ! > This option was present in 8.2 but is no longer present in 8.4.0 ! ! It is pr

Re: [BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Magnus Hagander
On Wed, Jul 22, 2009 at 17:29, Peter Much wrote: > On Wed, Jul 22, 2009 at 11:52:32AM +0200, Magnus Hagander wrote: > ! On Wed, Jul 22, 2009 at 11:42, Peter Much > wrote: > > Now understanding it, I bow in respect - this is indeed a fine > improvement! Thanks :-) > ! > But _there_is_no_such_thi

[BUGS] BUG #4934: regression in IN with joins in subselect

2009-07-22 Thread Benjamin Reed
The following bug has been logged online: Bug reference: 4934 Logged by: Benjamin Reed Email address: ran...@opennms.org PostgreSQL version: 8.4.0 Operating system: Mac OS X 10.5 Description:regression in IN with joins in subselect Details: I've hit a regression vs.

Re: [BUGS] BUG #4934: regression in IN with joins in subselect

2009-07-22 Thread Tom Lane
"Benjamin Reed" writes: > I've hit a regression vs. PostgreSQL 8.2 and 8.3 (and probably others) > related to subselects. This query: It's not going to be possible to examine this with just the query. You need to provide a self-contained test case. regards, tom lane --

Re: [BUGS] BUG #4934: regression in IN with joins in subselect

2009-07-22 Thread Benjamin Reed
On 7/22/09 4:39 PM, Tom Lane wrote: > "Benjamin Reed" writes: >> I've hit a regression vs. PostgreSQL 8.2 and 8.3 (and probably others) >> related to subselects. This query: > > It's not going to be possible to examine this with just the query. > You need to provide a self-contained test case.

Re: [BUGS] BUG #4934: regression in IN with joins in subselect

2009-07-22 Thread Tom Lane
Benjamin Reed writes: > Attached is a test case, including the query that causes the error at > the end. On 8.3, it returns 1 row (192.168.1.1), on 8.4 including the > git 8.4 branch, it returns none. Thanks, it seems like the problem is that it's applying *both* its methods for implementing an