X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EC70D9921 for ; Tue, 27 Sep 2005 12:11:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34320-05 for ; Tue, 27 Sep 2005 15:11:26 +0000 (GMT) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by svr1.postgresql.org (Postfix) with ESMTP id 0EBE2D990A for ; Tue, 27 Sep 2005 12:11:25 -0300 (ADT) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.44) id 1EKH76-0000pS-3V; Tue, 27 Sep 2005 17:11:24 +0200 In-Reply-To: <43395F1F.4070101@brandywine.com> References: <413a156ac3889b31bc079d099a110814@Chaos1.DE> <43395F1F.4070101@brandywine.com> Mime-Version: 1.0 (Apple Message framework v622) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: mike@fuhr.org, pgsql-sql@postgresql.org From: Axel Rau Subject: Re: Updating cidr column with network operator Date: Tue, 27 Sep 2005 17:11:22 +0200 To: daryl@brandywine.com X-Mailer: Apple Mail (2.622) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 required=5 tests=[AWL=0.040] X-Spam-Level: X-Archive-Number: 200509/270 X-Sequence-Number: 22817 Am 27.09.2005 um 17:02 schrieb Daryl Richter: > > Ok, I guess, but isn't tit true now that you can insert a new address > row which doesn't belong to any valid network?? Yes, I can. But in the earlier approach, the fk pointed at a special row in network ("UNKNOWN"), which maks no big difference. It's the nature of my ids/abuse application, that there are always faked source addresses, which may not belong to any routed net. Axel Axel Rau, Frankfurt, Germany +49-69-951418-0