| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| 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:34:29 |
| Message-ID: | alpine.DEB.2.10.1507272032380.3538@sto |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2015-07-27 19:20:33 | Segfault in pg_stat_activity |
| Previous Message | Alvaro Herrera | 2015-07-27 18:04:50 | Re: BUG #13442: ISBN doesn't always roundtrip with text |