Re: 7.3.5 - Mailing list pgsql-admin

From Tom Lane
Subject Re: 7.3.5
Date
Msg-id 2245.1068046590@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.5  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
"Donald Fraser" <demolish@cwgsy.net> writes:
> The fix I am looking for in 7.3.5, which is in the 7.4 branch, is for the
> regproc-reverse-conversion problem (the error comes when the planner tries
> to convert that string back to OID form).

IIRC there is no solution to that without moving to 7.4 --- the fix
required a change in the representation of data values in pg_statistic.

The best workaround I can recommend in 7.3 is to delete the pg_statistic
rows that relate to regproc columns.

            regards, tom lane

pgsql-admin by date:

Previous
From: "skennedy"
Date:
Subject: Re: Creating users in a second postgres server.
Next
From: Andrew Sullivan
Date:
Subject: Re: PGSQL Mailing List Reply-To field