From: | Jeff Amiel <jamiel(at)istreamimaging(dot)com> |
---|---|
To: | Jeff Amiel <jeff(dot)amiel(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: MAGIC_MODULE and libc |
Date: | 2006-12-19 14:32:02 |
Message-ID: | 4587F7E2.1010703@istreamimaging.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yup...
I did this
CREATE OR REPLACE FUNCTION getpid()
RETURNS integer AS
$BODY$
DECLARE
thepid integer;
BEGIN
select into thepid pg_backend_pid from pg_backend_pid();
return thepid;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
thanks!!!
Martijn van Oosterhout wrote:
> On Tue, Dec 19, 2006 at 08:20:23AM -0600, Jeff Amiel wrote:
>
>> ERROR: incompatible library "/lib/libc.so.6": missing magic block
>> SQL state: XX000
>> Hint: Extension libraries are required to use the PG_MODULE_MAGIC macro.
>>
>> I've added the appropriate macro to all my actual C code...but in this
>> case surely I am not expected to recompile libc...am I? Is there an
>> easier way to get the pid of the current process?
>>
>
> In general you should use a wrapper library, but in your case
> pg_backend_pid() will do it.
>
> Have a nice day,
>
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2006-12-19 14:46:13 | Re: Second attempt, roll your own autovacuum |
Previous Message | Martijn van Oosterhout | 2006-12-19 14:27:17 | Re: MAGIC_MODULE and libc |