Thread: C Extension woes
Hello all, I am trying to write an extension in C that returns a simple environment variable. The code compiles without any complaint or warning, and it loads fine into the database, however, when I run the function, I get disconnected from the server. Here is my C code: #include <postgres.h> #include <fmgr.h> PG_MODULE_MAGIC; #include <stdio.h> #include <stdlib.h> PG_FUNCTION_INFO_V1(pl_masterkey); text * pl_masterkey(PG_FUNCTION_ARGS) { char *e_var = getenv("PGMASTERKEY"); size_t length = VARSIZE(e_var) - VARHDRSZ; text * mkey = (text *) palloc(length); VARATT_SIZEP(mkey) = length; memcpy(VARDATA(mkey), e_var, length); return mkey; } And here is the SQL I use to create the function in PostgreSQL: CREATE FUNCTION pl_masterkey() RETURNS text AS 'pl_masterkey', 'pl_masterkey' LANGUAGE C STRICT; And the results: select pl_masterkey(); server closed the connection unexpectedly This probably means the server terminated abnormally before or whileprocessing the request. The connection to the server was lost. Attempting reset: Failed. !> Thanks ahead of time for any and all help.
Tim Hawes wrote: > Hello all, > > I am trying to write an extension in C that returns a simple environment > variable. The code compiles without any complaint or warning, and it > loads fine into the database, however, when I run the function, I get > disconnected from the server. > > Here is my C code: > > #include <postgres.h> > #include <fmgr.h> > PG_MODULE_MAGIC; > > #include <stdio.h> > #include <stdlib.h> > > PG_FUNCTION_INFO_V1(pl_masterkey); > > text * pl_masterkey(PG_FUNCTION_ARGS) > { > char *e_var = getenv("PGMASTERKEY"); > size_t length = VARSIZE(e_var) - VARHDRSZ; > > text * mkey = (text *) palloc(length); > VARATT_SIZEP(mkey) = length; > memcpy(VARDATA(mkey), e_var, length); > > return mkey; > } Oh, you confused a lot of things. You need something like Datum pl_masterkey(PG_FUNCTION_ARGS) { char *e_var = getenv("PGMASTERKEY"); PG_RETURN_TEXT_P(cstring_to_text(e_var)); } You don't need to mess with anything varlena-related (liek VARSIZE), it's all handled for you. Also, read up on how to declare user-defined C functions in Postgres (they always need to return Datum). Cheers, Jan -- Jan Urbanski GPG key ID: E583D7D2 ouden estin
Tim Hawes wrote: > > text * pl_masterkey(PG_FUNCTION_ARGS) > { > char *e_var = getenv("PGMASTERKEY"); > size_t length = VARSIZE(e_var) - VARHDRSZ; > > The VARSIZE macro is for variable length structures, like a text or bytea which contains a length and data member. You are using this macro on a regular C string "e_var". Try this instead: size_t length = e_var != NULL ? strlen(e_var) : 0; -- Andrew Chernow eSilo, LLC every bit counts http://www.esilo.com/
Andrew Chernow <ac@esilo.com> writes: > Tim Hawes wrote: >> char *e_var = getenv("PGMASTERKEY"); >> size_t length = VARSIZE(e_var) - VARHDRSZ; > The VARSIZE macro is for variable length structures, like a text or > bytea which contains a length and data member. You are using this macro > on a regular C string "e_var". The code on the output side is wrong too: if the useful data length is "length", then the palloc has to ask for length + VARHDRSZ, and that's also what's got to be put into the length word. regards, tom lane
Thank you for your replies, however, it still is not working, see below... Andrew Chernow wrote: > Tim Hawes wrote: >> >> text * pl_masterkey(PG_FUNCTION_ARGS) >> { >> char *e_var = getenv("PGMASTERKEY"); >> size_t length = VARSIZE(e_var) - VARHDRSZ; >> >> > > The VARSIZE macro is for variable length structures, like a text or > bytea which contains a length and data member. You are using this > macro on a regular C string "e_var". Try this instead: > > size_t length = e_var != NULL ? strlen(e_var) : 0; > @Jan: It appears the cstring_to_text function is unique to the latest PostgreSQL code. I do not have a def for that for PostgreSQL 8.2, and currently I am stuck working with that version. I changed the return value to Datum, and I had previously only copied from the examples at: http://www.postgresql.org/docs/8.2/interactive/xfunc-c.html @Andrew: here is my new code:Datum pl_masterkey(PG_FUNCTION_ARGS) { char *e_var = getenv("PGMASTERKEY"); size_t length = e_var != NULL ? strlen(e_var) : 0; text * mkey = (text *) palloc(length); VARATT_SIZEP(mkey) = length; memcpy(VARDATA(mkey), e_var, length); PG_RETURN_TEXT_P(mkey); } now gets: select pl_masterkey(); ERROR: invalid memory alloc request size 4294967293
Tim Hawes wrote: > @Jan: > It appears the cstring_to_text function is unique to the latest > PostgreSQL code. I do not have a def for that for PostgreSQL 8.2, and Oh, I'm sorry, I forgot about that. cstring_to_text has been added only recently (it's not even it 8.3, silly me). > Datum pl_masterkey(PG_FUNCTION_ARGS) > { > char *e_var = getenv("PGMASTERKEY"); > size_t length = e_var != NULL ? strlen(e_var) : 0; > > text * mkey = (text *) palloc(length); > VARATT_SIZEP(mkey) = length; > memcpy(VARDATA(mkey), e_var, length); > > PG_RETURN_TEXT_P(mkey); > } You forgot to palloc space for the varlena header. You need an extra VARHDRSZ bytes for the header, in addition to what is needed for your data. Try something like this: Datum pl_masterkey(PG_FUNCTION_ARGS) { char *e_var; size_t length; text *mkey; e_var = getenv("PGMASTERKEY"); length = e_var ? strlen(e_var) : 0; mkey = (text *) palloc(VARHDRSZ + length); VARATT_SIZEP(mkey) = VARHDRSZ + length; memcpy(VARDATA(mkey), e_var, length); PG_RETURN_TEXT_P(mkey); } -- Jan Urbanski GPG key ID: E583D7D2 ouden estin
Ok, that worked! Thank you very much, Jan and others who gave their input. I did see Tom's input for the VARHDRSZ and tried that, but forgot to add that again when I called VARATT_SIZEP Jan Urbański wrote: > Tim Hawes wrote: > >> @Jan: >> It appears the cstring_to_text function is unique to the latest >> PostgreSQL code. I do not have a def for that for PostgreSQL 8.2, and > > Oh, I'm sorry, I forgot about that. cstring_to_text has been added > only recently (it's not even it 8.3, silly me). > >> Datum pl_masterkey(PG_FUNCTION_ARGS) >> { >> char *e_var = getenv("PGMASTERKEY"); >> size_t length = e_var != NULL ? strlen(e_var) : 0; >> >> text * mkey = (text *) palloc(length); >> VARATT_SIZEP(mkey) = length; >> memcpy(VARDATA(mkey), e_var, length); >> >> PG_RETURN_TEXT_P(mkey); >> } > > You forgot to palloc space for the varlena header. You need an extra > VARHDRSZ bytes for the header, in addition to what is needed for your > data. > Try something like this: > > Datum > pl_masterkey(PG_FUNCTION_ARGS) > { > char *e_var; > size_t length; > text *mkey; > > e_var = getenv("PGMASTERKEY"); > length = e_var ? strlen(e_var) : 0; > mkey = (text *) palloc(VARHDRSZ + length); > > VARATT_SIZEP(mkey) = VARHDRSZ + length; > memcpy(VARDATA(mkey), e_var, length); > > PG_RETURN_TEXT_P(mkey); > } >