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

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

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

In response to

Responses

pgsql-admin by date

Next:From: Dave PageDate: 2003-07-10 16:30:17
Subject: Re: [ADMIN] Overloading functions that are used by operators.
Previous:From: Dave PageDate: 2003-07-10 15:52:50
Subject: Re: [ADMIN] Overloading functions that are used by operators.

pgadmin-support by date

Next:From: Dave PageDate: 2003-07-10 16:30:17
Subject: Re: [ADMIN] Overloading functions that are used by operators.
Previous:From: Dave PageDate: 2003-07-10 15:52:50
Subject: Re: [ADMIN] Overloading functions that are used by operators.

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