LPP> At the moment this has to be done for each Postgres database used
LPP> by Elephant. Any objections on doing this automatically if needed?
we have this:
(defun init-stored-procedures (con)
(safe-ignore-postgres-error (con)
(cl-postgres:exec-query con "CREATE LANGUAGE plpgsql;"))
but it fails:
[EMAIL PROTECTED]:~$ psql -c "create language plpgsql" elepm
ERROR: must be superuser to create procedural language
no big deal, i have a script that re-creates database:
#!/bin/bash
dropdb elepm
createdb elepm
psql -c "grant all on database elepm to alex"
psql -c "create language plpgsql" elepm
i execute it as postgres via sudo -u.
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
