The ip column should not be varchar or text.

It should be inet.

The proper fix is:

  alter table supermasters alter COLUMN ip type inet using ip::inet;

and change the sql which creates the table during install to use inet
for that column.

That column is only supposed to hold ipv4 or ipv6 addresses, which is
exactly what the inet type is for.

As an added bonus, inet stores the address as an integer, so it should
take up less space than a text/varchar/char column.

-JimC
-- 
James Cloos <cl...@jhcloos.com>         OpenPGP: 1024D/ED7DAEA6


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to