[SQL] Encrypt data type LO

2004-11-24 Thread Alberto PiƱa
Hi fellows, I need to encrypt fields of data type LO (LO is included in the contrib section of PostgreSQL) and I dont know if pgcrypto is the way to do that or there is another way. If anyone knows the answer of my problem or know an alternative way to do this, Ill appreciate you can share

[SQL] Explicitly rolling back transaction from within a C-Language function

2004-11-24 Thread Mark Dilger
Hello, I have a transactional system built on top of BerkeleyDB which I would like to call from within Postgres through a C-Language function. The behavior of the function will be read-only. Even so, the BerkeleyDB-based system's transaction will sometimes fail. What I would like to do is

Re: [SQL] Explicitly rolling back transaction from within a C-Language function

2004-11-24 Thread Michael Fuhr
On Wed, Nov 24, 2004 at 11:23:30AM -0800, Mark Dilger wrote: To clarify what I think I want: I would like the C-Language function to return an error condition to Postgres that will cause the current Postgres transaction to abort. I do not know how to do this. See the Reporting Errors