Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector'

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-28 22:24:30
Message-ID: 11596.1409264670@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> Eric Malm <emalm(at)pivotal(dot)io> writes:
>> 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've pushed a fix for this, if you need it right away:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f7eec89b66947e4098773cf286653b9c4f01c88

That's against HEAD but it's the same in all the back branches.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-08-28 23:00:57 Re: [BUGS] BUG #10823: Better REINDEX syntax.
Previous Message m.woehling 2014-08-28 21:37:51 BUG #11304: UNION query with NULL values fails