| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Having a problem with RoR-3.1.1 and Pg-9.1 |
| Date: | 2012-02-27 19:30:53 |
| Message-ID: | 4F4BD9ED.3060401@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Blackwell | 2012-02-27 19:31:00 | Orphaned temp table |
| Previous Message | David Salisbury | 2012-02-27 19:29:43 | Re: Having a problem with RoR-3.1.1 and Pg-9.1 |