D. Stimits wrote:
> A google search shows very little concerning the pg_detoast_datum > undefined reference link error. It is looking more like the V1 has to > be skipped and I'll have to go back to V0 if I can't get this to work.
You haven't shown us your function, so it's a bit difficult to help, but in any case you do *not* want to use the V0 calling conventions -- they are deprecated and subject to removal in the future. V1 certainly works -- I've done many V1 C functions that accept text arguments. Take a look at some of the contrib folder extensions if you need examples.
> unless someone can magically make the default PostgreSQL version on RH > 7.3 change to a newer version of PostgreSQL, then a newer version > can't be used]
Why not? I have Postgres 7.3.4 running on my RH 7.3 server. Here are RH 7.3 RPMs: ftp://ftp8.us.postgresql.org/pub/pgsql/binary/v7.3.4/RPMS/redhat-7.3/
I'll consider this, but it greatly complicates things to require users add the non-redhat version. I understand the benefits of doing so, but convincing people to do this just to try out a package is not so easy.
Joe
Here is a simple echo function that is being used:
#include <pgsql/server/postgres.h> #include <string.h> #include <pgsql/server/fmgr.h>
PG_FUNCTION_INFO_V1(reverse_path); Datum my_echo(PG_FUNCTION_ARGS) { text* arg = PG_GETARG_TEXT_P(0); text* echo_arg = (text *)palloc(sizeof(arg)); memcpy( (void *)(echo_arg), (void *)(arg), sizeof(arg) ); PG_RETURN_TEXT_P(echo_arg); }
Keep in mind that this isn't being run yet, it fails at link stage. As another test, I have simplified the above just to test link time (not intended to run, just as a test of link/compile):
#include <pgsql/server/postgres.h> #include <pgsql/server/fmgr.h>
PG_FUNCTION_INFO_V1(reverse_path); Datum my_echo(PG_FUNCTION_ARGS) { text* arg = PG_GETARG_TEXT_P(0); PG_RETURN_TEXT_P(arg); }
The first function complains at link time of missing link function pg_detoast_datum, CurrentMemoryContext, and MemoryContextAlloc, while the latter complains only of missing pg_detoast_datum.
In both cases, link libraries are: -lkrb5 -lk5crypto -lcom_err -lpq -ldl
Now I am still scratching my head, wondering how it is that pg_detoast_datum is a V0 function, and I can compile V0 libraries just fine, but can't even compile a V1, which supposedly does not use pg_detoast_data? The additional link failures when using palloc make me feel there is some mysterious unnamed library that is missing when using V1, aside from -lpq. When I go in to compile the src/test/regress/ directory of the source from the rpm used in Redhat 7.3, I see no signs that anything else is required. Something simple must be missing under the PostgreSQL 7.2 version. Is there a separate library that needs linking under a V1 interface, in addition to those named above?
D. Stimits
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]