[GENERAL] Debugging custom type libraries

2009-02-18 Thread Will Harrower
Hi, I'm writing a custom type, with the associated functions (type_in, type_out, etc) written in C, in an external shared library that Postgres loads at runtime. I was wondering what the best way of debugging these functions is... I can start postgres through gdb, but can't figure out how to

[GENERAL] Pointers in custom types

2009-02-21 Thread Will Harrower
Hi, I'm writing a custom type in C that needs to manage two byte arrays (among other things). I have attempted to implement this using something similar to the following struct (along with corresponding input and output functions): typedef struct example { bytea* first; bytea* second;

Re: [GENERAL] Pointers in custom types

2009-02-21 Thread Will Harrower
Tom Lane wrote: Will Harrower writes: I'm writing a custom type in C that needs to manage two byte arrays (among other things). I have attempted to implement this using something similar to the following struct (along with corresponding input and output functions): ty

Re: [GENERAL] Looking for advice on database encryption

2009-04-17 Thread Will Harrower
Bill Moran wrote: John R Pierce wrote: Eric Soroos wrote: an index on the encrypted SSN field would do this just fine. if authorized person needs to find the record with a specific SSN, they encrypt that SSN and then look up the ciphertext in the database... done. This