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

On Mon, Jul 27, 2015 at 2:15 AM, Fabien COELHO <coelho@cri.ensmp.fr> 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!).
>

You can't test extension upgrade scripts by running the component
statements at the command line.  You have to make an actual dummy upgrade
script and test it via "alter extension ... update ...".  When executed in
that context, they are exempted from the rule you are running into.  (Or
maybe there is another way that I don't know of).

But I wonder what will happen when you try to drop a type which is in use?

Cheers,

Jeff