IPv6 link-local addresses and init data type
От
Tom Dunstan
Тема
IPv6 link-local addresses and init data type
Дата
Msg-id
39FCD58F-B318-43BE-8FEE-4345AA94BCD8@tomd.cc
Список
Дерево обсуждения
IPv6 link-local addresses and init data type Tom Dunstan <pgsql@tomd.cc>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Tom Dunstan <pgsql@tomd.cc>
Re: IPv6 link-local addresses and init data type Haribabu Kommi <kommi.haribabu@gmail.com>
Re: IPv6 link-local addresses and init data type Andreas Karlsson <andreas@proxel.se>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Andreas Karlsson <andreas@proxel.se>
Re: IPv6 link-local addresses and init data type Markus Wanner <markus@bluegap.ch>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Markus Wanner <markus@bluegap.ch>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Markus Wanner <markus@bluegap.ch>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Robert Haas <robertmhaas@gmail.com>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Re: IPv6 link-local addresses and init data type Haribabu Kommi <kommi.haribabu@gmail.com>
Re: IPv6 link-local addresses and init data type Markus Wanner <markus@bluegap.ch>
Re: IPv6 link-local addresses and init data type Haribabu Kommi <kommi.haribabu@gmail.com>
Re: IPv6 link-local addresses and init data type Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: IPv6 link-local addresses and init data type Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: IPv6 link-local addresses and init data type Haribabu Kommi <kommi.haribabu@gmail.com>
Re: IPv6 link-local addresses and init data type Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: IPv6 link-local addresses and init data type Robert Haas <robertmhaas@gmail.com>
Re: IPv6 link-local addresses and init data type Tom Lane <tgl@sss.pgh.pa.us>
Hi all
I just ran into an issue that was originally reported way back in 2007 - https://www.postgresql.org/message-id/flat/0262B803-B664-4EBE-85B4-3C9A40EA6CDA@mobygames.com
Basically the inet data type cannot store or parse valid ipv6 address literals with a scope / zone id suffix. Apparently the combination of virtualised linux, ipv6 network and JVM that we are using has combined to report connections on localhost as coming from ‘::1%0’, which our app is unsuccessfully attempting to store in the db in an inet column. This is the first time that I have ever seen this, but perhaps it will get more common as ipv6-first usage increases.
Given that inet is a varlena struct with only known-length fields, it seems potentially possible to extend it to add an optional, variable length zone id on the end, with the result being backwards compatible with existing data.
Thoughts?
Cheers
Tom
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Michael Meskes
Дата: