Changeset 599 for trunk/dns.sql

Timestamp:

03/21/14 16:44:13 (10 years ago)

Author:

Kris Deugau

Message:

/trunk

Prepare for changes to allow any record in either forward or reverse
zones, no matter how silly.

This commit adds a database function to catch errors with CASTing a
column as inet, so that any place we need to sort records based on the
IP value of a column succeeds by treating non-IP values as 0.0.0.0/0.

File:

• trunk/dns.sql (modified) (2 diffs)

trunk/dns.sql

@@ -6 +6 @@
 -- SET SESSION AUTHORIZATION 'dnsdb';
 
+-- pre-pg8.3, this must be run as a superuser
+CREATE LANGUAGE plpgsql;
+-- it's required for:
+
+-- Return proper conversion of string to inet, or 0.0.0.0/0 if the string is
+-- not a valid inet value.  We need to do this to support "funky" records that
+-- may not actually have valid IP address values.  Used for ORDER BY
+CREATE OR REPLACE FUNCTION inetlazy (rdata text) RETURNS inet AS $$
+BEGIN
+        RETURN CAST(rdata AS inet);
+EXCEPTION
+        WHEN OTHERS THEN
+                RETURN CAST('0.0.0.0/0' AS inet);
+END;
+$$ LANGUAGE plpgsql;
+
+
 -- need a handy place to put eg a DB version identifier - useful for auto-upgrading a DB
 CREATE TABLE misc (
@@ -14 +31 @@
 
 COPY misc (misc_id, key, value) FROM stdin;
-1       dbversion       1.2
+1       dbversion       1.2.4
 \.