From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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:30:17 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B83AF172@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-admin |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 10 July 2003 17:07
> To: Dave Page
> Cc: Donald Fraser; [ADMIN]; [pgADMIN]
> Subject: Re: [ADMIN] [pgadmin-support] Overloading functions
> that are used by operators.
>
>
> "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.
Yeah, that sounds like it. The simplified query stops the conversion to
oid by just returning the function name rather than joining with
pg_proc. Works just as well for us I think and simplifies the query
somewhat.
Thanks for looking.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Fraser | 2003-07-10 17:10:52 | Re: [ADMIN] Overloading functions that are used by operators. |
Previous Message | Tom Lane | 2003-07-10 16:06:35 | Re: [ADMIN] Overloading functions that are used by operators. |
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Fraser | 2003-07-10 17:10:52 | Re: [ADMIN] Overloading functions that are used by operators. |
Previous Message | Tom Lane | 2003-07-10 16:06:35 | Re: [ADMIN] Overloading functions that are used by operators. |