On: Fri, 24 Feb 2012 07:33:01 -0800, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On Friday, February 24, 2012 7:16:47 am James B. Byrne > wrote: >> CentOS-5.7 >> RoR-3.1.1 >> Pg-9.1 >> >> I am trying to run a test suite against Pg-9.1 for a >> RoR-3.1.1 based application. When I run the test DB >> setup task it fails: >> >> $ rake db:test:prepare >> Using AdapterExtensions >> psql:/...rails3/db/development_structure.sql:22: ERROR: >> must be owner of extension plpgsql >> >> >> The offending line in development_structure.sql is: >> >> COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural >> language'; >> >> The error does not happen if the target DBMS is >> Pg-8.4. I recall that with 8.4 that we would see >> warnings relating to trying to load/create plpgsql >> when it already existed in the test database but >> now we are getting an error which stops further >> processing. Is there a way around this? See here for similar report: http://archives.postgresql.org/pgsql-general/2012-02/msg00504.php 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. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@xxxxxxxxxxxxx Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
