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.klaver@gmail.com