Re: backend reset of database - Mailing list pgsql-general

From Tom Lane
Subject Re: backend reset of database
Date
Msg-id 9106.1176143480@sss.pgh.pa.us
Whole thread Raw
In response to Re: backend reset of database  (Magnus Hagander <magnus@hagander.net>)
Responses Re: backend reset of database  (Magnus Hagander <magnus@hagander.net>)
Re: backend reset of database  (Geoffrey <esoteric@3times25.net>)
List pgsql-general
Magnus Hagander <magnus@hagander.net> writes:
> Geoffrey wrote:
>> CREATE OR REPLACE FUNCTION pcm_getmiles_s(text,text,integer)
>> RETURNS float8 AS '/esc/pgrnd/prog/libpcmiler'
>> LANGUAGE 'c' WITH (isStrict);

> Is this function actually a PostgreSQL callable function? Or is it just
> a general C function along the line of
> float pcm_getmiles_s(char*, char*, int)
> ?

The code would never have worked at all if that were the case (since
text* is not like char*).  I suspect some subtler portability issue in
Geoffrey's glue functions.  It seems unlikely that moving from PG 7.4.13
to 7.4.16 would in itself have exposed such a problem, but the update in
operating environment from RHEL3 to RHEL4 might've.

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: backend reset of database
Next
From: Magnus Hagander
Date:
Subject: Re: backend reset of database