Re: Having a problem with RoR-3.1.1 and Pg-9.1

Поиск
Список
Период
Сортировка
От James B. Byrne
Тема Re: Having a problem with RoR-3.1.1 and Pg-9.1
Дата
Msg-id 31f7e1d6513fdc63defda59c6372b48e.squirrel@webmail.harte-lyne.ca
обсуждение исходный текст
Ответ на Re: Having a problem with RoR-3.1.1 and Pg-9.1  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
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:ByrneJB@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


В списке pgsql-general по дате отправления:

Предыдущее
От: "James B. Byrne"
Дата:
Сообщение: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought