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

From Tom Lane
Subject Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector'
Date
Msg-id 11596.1409264670@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Error with citext extension when upgrading from 9.0.3 to 9.3.5: 'cannot cast type oid[] to oidvector'  (Eric Malm <emalm@pivotal.io>)
List pgsql-bugs
I wrote:
> Eric Malm <emalm@pivotal.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

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #11283: PostgreSQL bug? function's variable type cached not flushed within session when the type altered.
Next
From: m.woehling@barthauer.de
Date:
Subject: BUG #11304: UNION query with NULL values fails