Postgres Pro
Downloads
Home   >   mailing lists

BUG #5071: abbrev() bug with IPv6 - Mailing list pgsql-bugs

From
Subject BUG #5071: abbrev() bug with IPv6
Date
Msg-id 200909220454.n8M4sm6c006957@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5071: abbrev() bug with IPv6  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5071
Logged by:
Email address:      alexander.over@koeln.de
PostgreSQL version: 8.3.7
Operating system:   Debian Lenny 64Bit
Description:        abbrev() bug with IPv6
Details:

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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5066: plperl issues with perl_destruct() and END blocks
Next
From: Annita Veneti
Date:
Subject: Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL