Index: installers/debian/dotlrn/postinst
===================================================================
RCS file: /usr/local/cvsroot/installers/debian/dotlrn/postinst,v
diff -u -r1.4 -r1.5
--- installers/debian/dotlrn/postinst	26 Mar 2008 13:42:16 -0000	1.4
+++ installers/debian/dotlrn/postinst	28 Mar 2008 10:33:16 -0000	1.5
@@ -115,11 +115,15 @@
         #        echo $error
         #fi
 
-	# Install plpgsql on database
+	# Install plpgsql on database and enable compatibility options
 	dbuser=$dba_name
 	dbpass=$dba_password
 	sqlfile=/tmp/dotlrn-create-plpgsql.sql
-	echo "CREATE LANGUAGE plpgsql;" > $sqlfile
+	echo "CREATE LANGUAGE plpgsql;
+		ALTER DATABASE dotlrn SET add_missing_from = on;
+		ALTER DATABASE dotlrn SET default_with_oids = on;
+		ALTER DATABASE dotlrn SET regex_flavor = extended;
+		" > $sqlfile
         . /usr/share/wwwconfig-common/pgsql-exec.sh
 	rm -f $sqlfile
         if [ "$status" = "error" ]