On Mon, February 27, 2012 14:30, Adrian Klaver wrote: > 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? > > Did some testing. So when you use 9.1 pg_dump to dump from > versions > prior to 9.1 it pulls a language in using CREATE OR > REPLACE langname > with no COMMENT on the language. If you use 9.1 pg_dump to > dump a 9.1 > database is uses the CREATE EXTENSION langname and adds > the COMMENT you > are seeing. As I know of no way to disable COMMENTs in a > dump you are left with my suggestion from previous post, > of running script as superuser. >
Then what is the value of the GRANT CREATE DATABASE TO userid ability if a user cannot create a database without superuser privileges? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:byrn...@harte-lyne.ca 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
