Re: BUG #13442: ISBN doesn't always roundtrip with text

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: BUG #13442: ISBN doesn't always roundtrip with text
Дата
Msg-id alpine.DEB.2.10.1507272032380.3538@sto
обсуждение исходный текст
Ответ на Re: BUG #13442: ISBN doesn't always roundtrip with text  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
>> Basically version 1.0 was confusing ISBN & ISBN13, and for upgrading the
>> ISBN type definition must be modified. However, there is no such thing as
>> ALTER TYPE, and trying DROP TYPE/ALTER TYPE is rejected because the type
>> belongs to an extension (hey I know that, this is what is being done!).
>
> If I understand this correctly, you need to ALTER EXTENSION .. DROP
> (which removes the type from the extension), then drop the type, create
> it fresh, then ALTER EXTENSION ADD to put it back.

Ok, so the upgrade script must do that manually, that is what I was
missing. I'll try that. Thanks.

--
Fabien.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13442: ISBN doesn't always roundtrip with text
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Segfault in pg_stat_activity