strange problem with ip6 - Mailing list pgsql-bugs

From Brian Hirt
Subject strange problem with ip6
Date
Msg-id 0262B803-B664-4EBE-85B4-3C9A40EA6CDA@mobygames.com
Whole thread Raw
Responses Re: strange problem with ip6  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-bugs
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 ;
ERROR:  invalid input syntax for type inet: "fe80::216:cbff:fe84:8ac2%
en0"
load=# select version();
                                                                 version
------------------------------------------------------------------------
----------------------------------------------------------------
PostgreSQL 8.2.4 on i386-apple-darwin8.9.1, compiled by GCC i686-
apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5341)
(1 row)

load=#

Any thoughts?

--brian

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql locks up over the net
Next
From: Russell Smith
Date:
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)