Re: Having a problem with RoR-3.1.1 and Pg-9.1

On 02/27/2012 08:51 AM, James B. Byrne wrote:
>
> The options seem to be run the script as the owner of the
> plpgsql EXTENSION or do not include the comment.
>
> How does one instruct pg_dump not to include the COMMENT
> for the plpgsql extension?

I am not sure pg_dump is including the COMMENT. From your previous post
the source of the COMMENT would seem to be development_structure.sql,
which I assume is coming from RoR.

>
> The case in question is the automated creation of an sql
> script to create a test database from a development
> database. The owners of the development and test
> databases are the same but this user id is not a superuser
> and it certainly does not own the plpgsql extension.

Run the script as a superuser? If the purpose is create a database from
scratch it would seem that would have to happen via a user with
sufficient privileges on all the objects in the database.

>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com