| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, bz(at)mailinator(dot)com, PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #13442: ISBN doesn't always roundtrip with text |
| Date: | 2015-07-27 18:04:50 |
| Message-ID: | 20150727180450.GI5596@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2015-07-27 18:34:29 | Re: BUG #13442: ISBN doesn't always roundtrip with text |
| Previous Message | Heikki Linnakangas | 2015-07-27 17:32:42 | Re: Memory leak in XLOG reader facility when decoding records (caused by WAL refactoring) |