has anybody used ctypes to call back into c program which embeds apython interpreter

H

Hannu Krosing

Hi,

I want to use ctypes to use some functions from postgreSQL server which
embeds python interpreter as language pl/python.

That is I want to use ctypes to call _back_ to some internal functions
in the server

What I tried is the following:

hannu=# create or replace function send_raw_notice(rn_text text)
returns text
language plpythonu
as
$$

from ctypes import *
import struct

pg = cdll.LoadLibrary('/usr/lib/postgresql/9.1/bin/postmaster')
pg.pq_flush()

return rn_text
$$;
CREATE FUNCTION
hannu=# select send_raw_notice('so you see me?');
The connection to the server was lost. Attempting reset: Failed.
!>

This caused a segfault:

2012-03-31 16:28:24 CEST LOG: server process (PID 8739) was terminated
by signal 11: Segmentation fault
2012-03-31 16:28:24 CEST LOG: terminating any other active server
processes

I suspect it is due to not calling into the host program (the running
server) but into a newly loaded and uninitialized copy of postmaster
loaded as library


Does anyone have ideas how to call into the embedding c program from
ctypes ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top