Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Overloading functions that are used by operators.

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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-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.

pgsql-admin by date

Next:From: Donald FraserDate: 2003-07-10 17:10:52
Subject: Re: [ADMIN] Overloading functions that are used by operators.
Previous:From: Tom LaneDate: 2003-07-10 16:06:35
Subject: Re: [ADMIN] Overloading functions that are used by operators.

pgadmin-support by date

Next:From: Donald FraserDate: 2003-07-10 17:10:52
Subject: Re: [ADMIN] Overloading functions that are used by operators.
Previous:From: Tom LaneDate: 2003-07-10 16:06:35
Subject: Re: [ADMIN] Overloading functions that are used by operators.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group