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

Fabien COELHO wrote:

> After some tests, it seems that an upgrade script cannot be provided,
> or I missed something.
>
> 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.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services