On 02/22/2013 02:25 PM, Kevin Grittner wrote:
To get owner to be bob you need to do:
\c bob
set role bob;
create extension plpgsql;
Good point, I forgot that the user was reset by \c.
Either way you still get the error on the COMMENT which is what is
tripping up the OP.
The good news is that it seems to be fixed on HEAD:
I should have been clearer, the problem is in the dump file created from
the database. When you try to restore it chokes on the COMMENT line
unless you do the restore as a superuser.
test=# drop database bob;
DROP DATABASE
test=# set role bob;
SET
test=> create database bob template template2;
CREATE DATABASE
test=> \c bob bob
You are now connected to database "bob" as user "bob".
bob=> create extension plpgsql;
CREATE EXTENSION
bob=> \dL
List of languages
Name | Owner | Trusted | Description
---------+-------+---------+------------------------------
plpgsql | bob | t | PL/pgSQL procedural language
(1 row)
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
