Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created
Дата
Msg-id CA+TgmoZBoPYon_Onz8kdou8oT8FiiepBP1e8WuDANCTMQ3kmNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
On Thu, Jul 5, 2012 at 9:32 AM, Bruce Momjian <bruce@momjian.us> wrote:
> On Thu, Jul 05, 2012 at 12:21:58AM -0400, Tom Lane wrote:
>> Bruce Momjian <bruce@momjian.us> writes:
>> >>> address the points I made about reproducing the previous state in cases
>> >>> where the admin removed the language or changed its permissions.
>>
>> >> Well, it still does the create extension in binary mode like before ---
>> >> not sure what the problem is.
>>
>> > Applied and back-patched to 9.2.
>>
>> I do not believe that this patch fixes the problem, and I also believe
>> that it creates new problems.  Please revert.
>
> I asked for an explaination of the problem, but received no reply:
>
>         http://archives.postgresql.org/pgsql-bugs/2012-07/msg00005.php
>
> so I assumed you were fine with it.  Please explain.  Does anyone else
> understand the problem Tom is seeing?

Well, the part I understood was that your fix apparently does not
guarantee to restore plpgsql to the state it was in, just to restore
it to existence.  But previous complaints about similar issues have
fallen on deaf ears (see bug #5184).  Perhaps Tom has had a change of
heart, but if so we have a few things to fix, not just this one.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Payal Singh
Дата:
Сообщение: Re: Problem with pg_upgrade
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created