From: pgsql@groks.org
To: pgsql-interfaces@postgresql.org
Subject: Type implemented in plpythonu crashes backend
Date: Wed, 11 Aug 2004 01:48:35 -0600
Message-ID: <1092210515.2350.100.camel@january.e-complex.ca> (raw)
I'd like to implement new postgres types in a language other than C for
prototyping speed. plpgsql won't let me create a function which takes a
cstring, and neither will pltcl. Happily, plpythonu will, and it seems
to work fine.
However, the code below causes the backend to crash...
I'm guessing that plpython is trying to format the return value using
the appropriate registered function, which just happens to be itself.
My goal is to prototype new types, operators and gist indexes without
getting bogged down in with the guts of posgresql in C, so if it's
unreasonable to expect the below code to work, do you have any other
suggestions?
Thanks.
create or replace function pycomplex_in(cstring)
returns opaque as '
import struct
import re
p = re.compile(" *\\( *([0-9]+(\\.[0-9]+)?) *, *([0-9]+(\\.[0-9]+)?)*\\)*")
m = p.match(args[0])
if m:
(x, y) = m.group(1, 3)
else:
(x, y) = (0, 0)
#plpy.error("incorrect format for pycomplex: %s" % args[0])
return struct.pack("dd", float(x), float(y))
' language plpythonu immutable strict;
create or replace function pycomplex_out(opaque)
returns cstring as '
import struct
(x, y) = struct.unpack("dd", args[0])
return "(%f, %f)", (x, y)
' language plpythonu immutable strict;
create type pycomplex (
internallength = 16,
input = pycomplex_in,
output = pycomplex_out,
alignment = double
);
select pycomplex_out(pycomplex_in('(1,2)'));
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgsql@groks.org
Subject: Re: Type implemented in plpythonu crashes backend
In-Reply-To: <1092210515.2350.100.camel@january.e-complex.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox