Re: [BUGS] strange problem with ip6

2007-05-18 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Tom Lane wrote: Christian Kratzer <[EMAIL PROTECTED]> writes: It's not that simple though. The ipv6 stack will propably not allow users to build sockets from addresses in link local scope from a specific interface to a server bound to a global address, ::1, or scoped

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Bruce Momjian
Tom Lane wrote: > Well, let's be clear: this is entirely the fault of the inet type not > accepting what we now know to be RFC-compliant address specifications. > So we ought to put fixing that on the TODO list. It's not happening > for 8.3 though, let alone in existing release branches, so we'd b

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Thu, May 17, 2007 at 02:39:55PM -0400, Tom Lane wrote: >> It seems the correct solution here is to extend the inet type to support >> RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, >> but we should probably put it on the TODO li

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Christian Kratzer <[EMAIL PROTECTED]> writes: > It's not that simple though. The ipv6 stack will propably not allow > users to build sockets from addresses in link local scope from a > specific interface to a server bound to a global address, ::1, or > scoped to any other interface. After all li

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Christian Kratzer <[EMAIL PROTECTED]> writes: > On Thu, 17 May 2007, Tom Lane wrote: >> As a temporary workaround, should we hack the server to suppress any >> %-foo found in the result of getnameinfo()? > Not sure what that would buy us. Mostly, it would buy us not having pg_stat_activity fail c

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Tom Lane wrote: It seems the correct solution here is to extend the inet type to support RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, but we should probably put it on the TODO list. propably yes. But we should bear in mind that addresses of dif

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 02:39:55PM -0400, Tom Lane wrote: > It seems the correct solution here is to extend the inet type to support > RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, > but we should probably put it on the TODO list. > > As a temporary workaround, should we hac

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Andrew Sullivan wrote: On Thu, May 17, 2007 at 07:29:47PM +0200, Christian Kratzer wrote: supporting scoped addresses could have their uses but then again theres nothing stopping you to bind multiple global ipv6 addresses to your loopback interface which would work fin

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: >> of a specific interface. This is why bsd based oprating systems append >> %ifname to the address so that they know which Interface this address > Oh, I forgot about that wart in RF

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 07:29:47PM +0200, Christian Kratzer wrote: > supporting scoped addresses could have their uses but then again > theres nothing stopping you to bind multiple global ipv6 addresses > to your loopback interface which would work fine for disconnected > setups and it might be a b

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Andrew Sullivan wrote: On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: of a specific interface. This is why bsd based oprating systems append %ifname to the address so that they know which Interface this address Oh, I forgot about that wart in RFC4

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Tom Lane wrote: Andrew Sullivan <[EMAIL PROTECTED]> writes: On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: I have postgresql installed on a mac, and I'm connecting from another mac on the network using ip6. When I try to select out of pg_stat_activity

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: > of a specific interface. This is why bsd based oprating systems append > %ifname to the address so that they know which Interface this address Oh, I forgot about that wart in RFC4007. Thanks for the cluestick. > There is prop

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: >> I have postgresql installed on a mac, and I'm connecting from another >> mac on the network using ip6. When I try to select out of >> pg_stat_activity i get this error. I suspect the

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: > I have postgresql installed on a mac, and I'm connecting from another > mac on the network using ip6. When I try to select out of > pg_stat_activity i get this error. I suspect the %en0 has something > to do with the problem, b

[BUGS] strange problem with ip6

2007-05-14 Thread Brian Hirt
I have postgresql installed on a mac, and I'm connecting from another mac on the network using ip6. When I try to select out of pg_stat_activity i get this error. I suspect the %en0 has something to do with the problem, but I'm no IP6 expert. load=# select * from pg_stat_activity ; ERRO