pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #18549: Support ipv6 link-local addresses in the inet type
3+ messages / 3 participants
[nested] [flat]

* BUG #18549: Support ipv6 link-local addresses in the inet type
@ 2024-07-22 16:07  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2024-07-22 16:07 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: git@j12t.org

The following bug has been logged on the website:

Bug reference:      18549
Logged by:          Johannes Ernst
Email address:      git@j12t.org
PostgreSQL version: 16.1
Operating system:   All
Description:        

One of the variations of ipv6 addresses is link-local addresses. It would be
nice if they could be stored in an inet column.

Example: fe80::249a:57ff:fed6:695f%host0/128 . Note the %host0



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #18549: Support ipv6 link-local addresses in the inet type
@ 2024-07-22 16:36  Tom Lane <tgl@sss.pgh.pa.us>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2024-07-22 16:36 UTC (permalink / raw)
  To: git@j12t.org; +Cc: pgsql-bugs@lists.postgresql.org

PG Bug reporting form <noreply@postgresql.org> writes:
> One of the variations of ipv6 addresses is link-local addresses. It would be
> nice if they could be stored in an inet column.

> Example: fe80::249a:57ff:fed6:695f%host0/128 . Note the %host0

This has been discussed in the past.  One problem is that there is no
cross-platform standardization of what the name following % can be.
So we couldn't do much better than accepting it on faith and storing
it as a string, which is not very nice.  It's also very unclear how
such a marker should affect the semantics of inet operators and
functions.

Maybe someday somebody will get motivated to try to surmount those
problems, but don't hold your breath.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #18549: Support ipv6 link-local addresses in the inet type
@ 2024-07-23 22:18  Johannes Ernst <git@j12t.org>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Johannes Ernst @ 2024-07-23 22:18 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Pgsql Bugs <pgsql-bugs@lists.postgresql.org>

Currently, this causes a crash in Mastodon as it attempts to store the source of an incoming HTTP request. Which isn't very nice.

It's not clear to me that Mastodon is the place where this string should be dealt with. Simply store it as uninterpreted string if that's what it is?

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2024-07-23 22:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-22 16:07 BUG #18549: Support ipv6 link-local addresses in the inet type PG Bug reporting form <noreply@postgresql.org>
2024-07-22 16:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2024-07-23 22:18   ` Johannes Ernst <git@j12t.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox