|
| |
150 |
150 |
# Install plpgsql on database and enable compatibility options |
|
| |
151 |
151 |
dbuser=$dba_name |
|
| |
152 |
152 |
dbpass=$dba_password |
|
| |
153 |
|
sqlfile=/tmp/dotlrn-create-plpgsql.sql |
|
| |
|
153 |
sqlfile=$(mktemp) |
|
| |
154 |
154 |
echo "CREATE LANGUAGE plpgsql; |
|
| |
155 |
155 |
ALTER DATABASE dotlrn SET add_missing_from = on; |
|
| |
156 |
156 |
ALTER DATABASE dotlrn SET default_with_oids = on; |