From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | "Donald Fraser" <demolish(at)cwgsy(dot)net>, "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>, "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: [ADMIN] Overloading functions that are used by operators. |
Date: | 2003-07-10 16:06:35 |
Message-ID: | 7189.1057853195@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-admin |
"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
>> I see no such error here ...
>>
>> regression=# create function pg_catalog.textcat(varchar,text)
>> regression-# returns text as 'textcat' language 'internal';
>> CREATE FUNCTION
> Andreas (Pflug) reckons it's gone in 7.4, but in 7.3.2 I see:
> [ complicated query ]
Oh. I'll bet you're running into the regproc-reverse-conversion
problem. 'textcat' is one of the histogram values appearing in pg_stats
for pg_operator.oprcode, right? The error comes when the planner tries
to convert that string back to OID form. We fixed this in 7.4 by
modifying the way that pg_statistic stores data values, so that no
conversion needs to occur.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-07-10 16:30:17 | Re: [ADMIN] Overloading functions that are used by operators. |
Previous Message | Dave Page | 2003-07-10 15:52:50 | Re: [ADMIN] Overloading functions that are used by operators. |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-07-10 16:30:17 | Re: [ADMIN] Overloading functions that are used by operators. |
Previous Message | Dave Page | 2003-07-10 15:52:50 | Re: [ADMIN] Overloading functions that are used by operators. |