On Sat, Nov 18, 2006 at 01:07:15PM -0800, J. Greg Davidson wrote: > Hello, > > My user-defined types are crashing the PostgreSQL server and I don't > understand why. I've been trying to figure it out on my own for overr > a week. I've cooked what I'm doing down to the essentials and I'm > asking for help. Help: What am I doing wrong? This may be a long shot but: > CREATE TYPE pair ( > INTERNALLENGTH = 4, -- 32-bits > INPUT = pair_in, > OUTPUT = pair_out > ); You're not specifying PASSEDBYVALUE, so I think postgres is assuming you're returning a *pointer* to 4 bytes, so it's dying trying to copy it. Hope this helps, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature