| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Eric Malm <emalm(at)pivotal(dot)io> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, cf-runtime-eng <cf-runtime-eng(at)pivotal(dot)io>, Luan Santos <lsantos(at)pivotal(dot)io> |
| Subject: | Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector' |
| Date: | 2014-08-27 23:28:45 |
| Message-ID: | 8349.1409182125@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Eric Malm <emalm(at)pivotal(dot)io> writes:
> We've encountered some errors when upgrading a database using the citext
> extension from 9.0.3 to 9.3.5. Specifically, we run pg_upgrade, then
> attempt to run 'CREATE EXTENSION citext FROM UNPACKAGED' to resolve
> collation errors on our citext columns. This produces the error message
> 'ERROR: cannot cast type oid[] to oidvector' when it runs the following
> command from contrib/citext/citext--unpackaged--1.0.sql:
Oh, that's annoying.
> We think this may be related to commit 7b63528,
Yeah, no doubt. I don't think there's anything wrong with that commit,
but we'll need to make the citext upgrade script even more of a kluge
in order to dodge the new restriction.
I'm thinking about regexp_replace on the text form of the oidvector :-(.
Anybody have a better idea?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2014-08-28 01:40:30 | Re: [BUGS] Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns |
| Previous Message | Dinesh Bhandary | 2014-08-27 19:39:35 | Re: BUG #11264: Auto vacuum wraparound job blocking everything |