Changeset 649 for branches/stable/dns.sql

Timestamp:

06/23/14 17:52:37 (10 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Subtle bugfix merge! All changes from /trunk r589 through r648 merged.

Location:

branches/stable

Files:

• . (modified) (1 prop)
• dns.sql (modified) (2 diffs)

branches/stable/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
 \.