On 2/27/12 9: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? 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.
My development_structure.sql file has the exact same line at the same place and narry a problem. I don't believe the pg_dump scripts are used at all in creation of development_structure.sql. I assume the user for running db:test:prepare, is the database.yml test: user. It will need super user privs for your test DB. -ds -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
