psycopg2.ProgrammingError: can't adapt type 'IPv4Address'

[billchenchina]

Please complete the following information:

• OS: Debian GNU/Linux 12
• Psycopg version: psycopg2==2.9.6
• Python version: 3.11.2
• PostgreSQL version: 15
• pip version: 23.0.1

Describe the bug
Please let us know:

1: what you did

import ipaddress
from datetime import datetime
import psycopg2
import psycopg2.extras
psycopg2.extras.register_ipaddress()
# blabla
with conn.cursor() as cur:
    cur.execute(
        r'INSERT INTO tablename (inet, timestamp) VALUES (%s, %s)',
        (ipaddress.ip_address('127.0.0.1'), datetime.now())
    )

2: what you expected to happen

ipaddress inserted into inet

3: what happened instead

psycopg2.ProgrammingError: can't adapt type 'IPv4Address'

psycopg2/lib/_ipaddress.py

Line 61 in 3450d15

for t in [ipaddress.IPv4Interface, ipaddress.IPv6Interface,

[dvarrazzo]

Weird. I have no idea why this function only handles Network and Interface address.

Psycopg 3 does it better.