From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Jeff Amiel <jeff(dot)amiel(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: MAGIC_MODULE and libc |
Date: | 2006-12-19 14:23:28 |
Message-ID: | 20061219142328.GH27098@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jeff Amiel wrote:
> I just upgraded to v8.2 and have an issue with one of my stored
> proc/functions that worked under 8.1:
>
> CREATE OR REPLACE FUNCTION getpid()
> RETURNS integer AS
> '/lib/libc.so.6', 'getpid'
> LANGUAGE 'c' VOLATILE;
>
> 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?
I'd use MyProcPid from #include "miscadmin.h"
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-12-19 14:27:17 | Re: MAGIC_MODULE and libc |
Previous Message | Kaloyan Iliev | 2006-12-19 14:22:40 | Float Infinity |