On Tue, Sep 22, 2009 at 12:54 AM, <alexander(dot)over(at)koeln(dot)de> wrote:
> The following bug has been logged online:
> Bug reference: 5071
> Logged by:
> Email address: alexander(dot)over(at)koeln(dot)de
> PostgreSQL version: 8.3.7
> Operating system: Debian Lenny 64Bit
> Description: abbrev() bug with IPv6
> I have a Database to store IPV6 addresses.
> Field "net" is type cidr.
> e.g.: '2001:400::/32' as value.
> "SELECT abbrev(net) FROM ipstore;"
> expected result: "2001:400::/32" (its already short v6)
> actual result: "2001:400/32" wich is invalid v6 Syntax.
I think this is the expected behavior. The same thing happens with IPv4.
rhaas=# select abbrev('18.104.22.168/24'::cidr);
It's also documented this way in the fine manual.
You can get the behavior you want by casting your cidr to an inet
before applying abbrev.
In response to
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2009-09-28 02:23:52|
|Subject: Re: Databse installation problem|
|Previous:||From: Robert Haas||Date: 2009-09-28 02:18:30|
|Subject: Re: Encounter shared memory error when running createlang command!|