Cannot properly initialize inet type fields in the table

From: fimarn <fimarn(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Cannot properly initialize inet type fields in the table
Date: 2007-09-26 13:55:37
Message-ID: 1190814937.645410.227250@n39g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a CREATE TABLE statement where I am trying to initialize
several inet fields, e.g.

CREATE TABLE myConfigTable
(
telnet bool DEFAULT
FALSE,
ftp bool DEFAULT
FALSE,
ipForwarding bool DEFAULT
FALSE,
configIntControlNetw inet DEFAULT
'1.1.0.0',
configIntControlMask inet DEFAULT '255.255.0.0'
);

When I try to execute an INSERT statement associated with this table I
am getting:

NOTICE: failed to convert IP address string, invalid inetstruct len
NOTICE: failed to convert IP address string, invalid inetstruct len

for each initialized inet field.

Does anyone know how to fix this problem? This code used to work under
psql version 7.2.1, but I am trying to make it work under 8.1.4.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2007-09-26 14:23:40 Re: pgcrypto & strong ciphers limitation
Previous Message Gokulakannan Somasundaram 2007-09-26 13:34:21 Re: Improving the Performance of Full Table Updates