Last change
on this file since 879 was 649, checked in by Kris Deugau, 11 years ago |
/branches/stable
Subtle bugfix merge! All changes from /trunk r589 through r648 merged.
|
File size:
649 bytes
|
Line | |
---|
1 | -- SQL upgrade file for dnsadmin 1.2.3 to 1.2.4 bugfix update
|
---|
2 |
|
---|
3 | -- pre-pg8.3, this must be run as a superuser
|
---|
4 | CREATE LANGUAGE plpgsql;
|
---|
5 | -- it's required for:
|
---|
6 |
|
---|
7 | -- Return proper conversion of string to inet, or 0.0.0.0/0 if the string is
|
---|
8 | -- not a valid inet value. We need to do this to support "funky" records that
|
---|
9 | -- may not actually have valid IP address values. Used for ORDER BY
|
---|
10 | CREATE OR REPLACE FUNCTION inetlazy (rdata text) RETURNS inet AS $$
|
---|
11 | BEGIN
|
---|
12 | RETURN CAST(rdata AS inet);
|
---|
13 | EXCEPTION
|
---|
14 | WHEN OTHERS THEN
|
---|
15 | RETURN CAST('0.0.0.0/0' AS inet);
|
---|
16 | END;
|
---|
17 | $$ LANGUAGE plpgsql;
|
---|
18 |
|
---|
19 | -- Update dbversion
|
---|
20 | UPDATE misc SET value='1.2.4' WHERE key='dbversion';
|
---|
Note:
See
TracBrowser
for help on using the repository browser.