[GENERAL] PGPOOL_HA

2008-03-04 Thread Luis Alberto Pérez Paz
Hi, I'm going to implement PGPOOL-II in my system. I was reading in the official site (http://pgfoundry.org/projects/pgpool/) and I found and excelent solution called PGPOOL-HA, however I've not found information of how implement this. Does anyone has implement it? In the positive case, can anyon

Re: [GENERAL] Postgresql + digital signature

2008-01-25 Thread Luis Alberto Pérez Paz
stamping service) or something like that and my problem grow. Thanks a lot for your advice (and your time). They were really helpful. Best Regards, On Jan 23, 2008 1:59 PM, Marko Kreen <[EMAIL PROTECTED]> wrote: > On 1/23/08, Luis Alberto Pérez Paz <[EMAIL PROTECTED]> wrote: >

Re: [GENERAL] Postgresql + digital signature

2008-01-23 Thread Luis Alberto Pérez Paz
Very interesting point of view. Yes, you're right about the manage key problem. The grant database access looks like a real solution. Thanks a lot for your advice. Best Regards, Luis Alberto Perez Paz On Jan 23, 2008 11:20 AM, David Wall <[EMAIL PROTECTED]> wrote: > > > We're in a stage wher

[GENERAL] Postgresql + digital signature

2008-01-22 Thread Luis Alberto Pérez Paz
ture doesn't verify. However before start I need your help to know: Is there in postgres something functionality like this? Does any know if there's something similar another database system? thanks in advance! Luis Alberto Pérez Paz

Re: [GENERAL] How can I retrieve a function result?

2006-06-13 Thread Luis Alberto Pérez Paz
Thank you Joachim, it woks!     Regards,   Luis A Perez Paz     On 6/13/06, Joachim Wieland <[EMAIL PROTECTED]> wrote: Luis,On Tue, Jun 13, 2006 at 01:19:32PM -0500, Luis Alberto Pérez Paz wrote:> The program works fine, actually I can verify that it executes the FUNCTION > 'myFun

Re: [GENERAL] How can I retrieve a function result?

2006-06-13 Thread Luis Alberto Pérez Paz
  Thanks in advance!       On 6/12/06, Joachim Wieland <[EMAIL PROTECTED]> wrote: Luis,On Mon, Jun 12, 2006 at 06:24:24PM -0500, Luis Alberto Pérez Paz wrote:> res = PQexecParams ( conn, "select myFunction($1,$2,$3)" , 3, NULL, > paramValues, paraLenghts, paramFormats, resu

[GENERAL] How can I retrieve a function result?

2006-06-12 Thread Luis Alberto Pérez Paz
Hi pgsql community,   I'm using libpq C. I'm trying to execute a FUNCTION called "myFunction",   * PGResult *res; res = PQexecParams ( conn, "select myFunction($1,$2,$3)" , 3, NULL, paramValues,

[GENERAL] Recovering a row result

2006-05-02 Thread Luis Alberto Pérez Paz
Hi everybody!   I'm migrating some sybase store procedures to postgres functions, In sybase I can write: -- create proc algo() as if exists (something)   return -900; else   SELECT * from tabla   return 0 -   Inside of my procedure I don't use the SELECT result, however I ca

[GENERAL] how can I check the error status??

2006-04-25 Thread Luis Alberto Pérez Paz
Hi everybody!   I'm migrating some sybase store procedures to postgres functions, I almost have found all that I need, however I dont know how to check the error status of the last transaction. I need to find in postgres the equivalent to the sybase @@error global variable.   I mean, how can I tran