Postgres Pro
Downloads
Home   >   mailing lists

BUG #5799: failed to find conversion function from unknown to text - Mailing list pgsql-bugs

From Sandro Santilli
Subject BUG #5799: failed to find conversion function from unknown to text
Date
Msg-id 201012211008.oBLA8evP038251@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5799: failed to find conversion function from unknown to text  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5799
Logged by:          Sandro Santilli
Email address:      strk@keybit.net
PostgreSQL version: 8.4.3
Operating system:   GNU/Linux 64bit
Description:        failed to find conversion function from unknown to text
Details:

Function definition:

 CREATE OR REPLACE FUNCTION ST_RelateMatch(text, text)
       RETURNS bool
       AS '$libdir/postgis-2.0', 'ST_RelateMatch'
       LANGUAGE 'C' IMMUTABLE STRICT
       COST 100;

Function invocation:

 SELECT a, b, ST_RelateMatch(a,b) FROM
  ( SELECT '101202FFF' as a, 'TTTTTTFFF' as b) as f;

Results in:

 ERROR:  failed to find conversion function from unknown to text

pgsql-bugs by date:

Previous
From: "Maxim Boguk"
Date:
Subject: BUG #5798: Some weird error with pl/pgsql procedure
Next
From: Dave Page
Date:
Subject: Re: BUG #5752: installer does not give proper os privileges on folders