Revision 6221
Added by Aaron Marcuse-Kubitza over 12 years ago
| Makefile | ||
|---|---|---|
| 219 | 219 |
-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin) |
| 220 | 220 |
-echo "CREATE DATABASE vegbien WITH OWNER bien TEMPLATE template1 \ |
| 221 | 221 |
ENCODING 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';"|$(psqlAsAdmin) |
| 222 |
-$(asAdmin) createlang hstore vegbien
|
|
| 222 |
-echo "CREATE EXTENSION hstore SCHEMA pg_catalog;"|$(psqlAsAdminVegbien)
|
|
| 223 | 223 |
-$(asAdmin) createlang plpython3u vegbien |
| 224 | 224 |
# ignore errors if user/database/etc. exists |
| 225 | 225 |
|
Also available in: Unified diff
root Makefile: VegBIEN DB: DB and bien user: mk_db: hstore extension: Fixed bug where need to use `CREATE EXTENSION hstore SCHEMA pg_catalog` instead of createlang, because hstore must be explicitly created in pg_catalog or else it will be created in the public schema instead, causing it to get deleted every time the public schema is reinstalled and cascading the delete to everything (including in other schemas) that uses hstore