Changeset 346 for branches/stable/cgi-bin

Timestamp:

10/06/06 12:18:04 (18 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Update SQL tabledef/database prep to create plpgsql procedural
language (which apparently only needs to be done once per
Postgres database cluster) and fix a bit of missing data in the
predefined alloctypes table data.

File:

• branches/stable/cgi-bin/ipdb.psql (modified) (2 diffs)

branches/stable/cgi-bin/ipdb.psql

@@ -4 +4 @@
 
 CREATE DATABASE ipdb;
+
+-- Need to do this or our triggers don't work.  Why do we need to do this?
+CREATE FUNCTION "plpgsql_call_handler" () RETURNS language_handler AS '$libdir/plpgsql' LANGUAGE C;
+CREATE TRUSTED LANGUAGE "plpgsql" HANDLER "plpgsql_call_handler";
 
 UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='ipdb')
@@ -148 +152 @@
 pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400 ISP-STATIC-DSL
 ac      Reserve for ATM ATM blocks      202     6750400 ISP
-fc      Reserve for fibre       203     6750400 ISP
+fc      Reserve for fibre       Fibre blocks    203     6750400 ISP
 wr      CORE/WAN block  CORE/WAN block  220     6750400 ISP
 pr      Dynamic-route DSL netblock      Dynamic-route DSL       221             ISP