strange problem with ip6

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Brian Hirt <bhirt(at)mobygames(dot)com>
Subject: strange problem with ip6
Date: 2007-05-15 02:32:21
Message-ID: 0262B803-B664-4EBE-85B4-3C9A40EA6CDA@mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Russell Smith 2007-05-15 08:50:22 Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Previous Message Tom Lane 2007-05-15 00:17:28 Re: postgresql locks up over the net