Re: mismatching proargtypes/proallargtypes (bug #10122)

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: mismatching proargtypes/proallargtypes (bug #10122)
Date: 2014-04-24 01:06:00
Message-ID: 20140424010600.GU25695@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> > 'trinque' on irc reported that "SELECT pg_catalog.pg_identify_object(oid,
> > integer, integer)'::regprocedure" doesn't work and Andrew Gierth noticed
> > it's because proargtypes doesn't match proallargtypes.
>
> Ugh, how annoying.

Argh!

> What I'm inclined to do in the back branches is just correct the
> catalogs without bumping catversion (since we can't do that).
> At least installations initdb'd in future will have it right.

Maybe we can provide an UPDATE to fix it in existing installations, for
those interested in doing so.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-04-24 01:26:47 Re: mismatching proargtypes/proallargtypes (bug #10122)
Previous Message Tom Lane 2014-04-24 00:37:33 Re: mismatching proargtypes/proallargtypes (bug #10122)