[GENERAL] i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt()

Hi, i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt(). I want to encrypt the data of column and then in a function decrypt that column using pgp_sym_encrypt() and pgp_sym_decrypt() functions. Its working fine with postgres 8.4 eg: select pgp_sym_encrypt('tushar','22'

[GENERAL] Can we use sqlcode in functions of plpgsql

Hi, For backward compatibility and some other reasons we want to use SQLCODE in our functions of PLPGSQL. But in Postgres Server 9.0 it gives error for SQLCODE. Is there any way to use SQLCODE in functions of PLPGSQL at the place of SQLSTATE? Also what is the datatype of SQLSTATE?

Re: [GENERAL] How to create database link and synonym in postgresql 9.0

27;); > > -- remote UPDATE: > CREATE RULE emp_upd AS ON UPDATE TO emp DO INSTEAD > SELECT dblink_exec( 'db2', > 'UPDATE emp SET id=' || quote_nullable(NEW.id) || ', name=' || > quote_nullable(NEW.name) > || ' WHERE id=' || quote_nu

[GENERAL] How to create database link and synonym in postgresql 9.0

Hi, In one of the migration porject want to access and update some tables from other database on same postgresql server. The question is how to access tables from other database on the same postgres server. If it is by database link like Oracle then what is the syntax. And how to create synonym?

Re: [GENERAL] Bidirectional replication

#x27;t get a return item from mksafefunc bucardo=# so there must be something wrong at mksafefunc or in that perl file. Any solution? On Wed, May 4, 2011 at 1:14 PM, tushar nehete wrote: > Hi Thanks to ALL, > John I tried Perl built into RHEL 5.5 but i got some errors so I download > ac

Re: [GENERAL] Bidirectional replication

Hi Thanks to ALL, John I tried Perl built into RHEL 5.5 but i got some errors so I download activeperl 5.12 and installed it. After that when start installation I stuck with the error, FAILED! (psql:/usr/local/share/bucardo/bucardo.schema:40: ERROR: didn't get a returINSTALLATION n item from mksa

Re: [GENERAL] Bidirectional replication

Thanks you all, I started with Bucardo. I installed activeperl 5.12 on my Linux(RHEL5.5) server. Can you please suggest some link which describe the installation steps in details. Thanks, Tushar On Tue, May 3, 2011 at 2:49 PM, Simon Riggs wrote: > On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wro

[GENERAL] Bidirectional replication

Hi, Is there any way to do bidirectional replication for Postgresql Plus Advance Server 8.4.5? I tried SLONY-I but its master-slave asynchronous replication. Can we configure master-master replication by slony? Or is there any trusted tool to do it? Regards, Tushar

Re: [GENERAL] Autocommit off - commits/rollbacks

Yes We can use exception for each statement to restrict the rollback. But how we can use SAVEPOINT and rollback to SAVEPOINT in the stored function or procedure in POSTGRES? We can only use the savepoints in transactions but not in stored functions. Regards, Tushar On Tue, Mar 29, 2011 at 12:54 P

[GENERAL] how to use savepoint and rollback in function

Hi All, In Postgresql we can use savepoint and rollback to savepoint in transaction. But we cannot use savepoint in function. Currently I am doing migration from Informix to Postgresql 8.4. In Informix they used Savepoint. Please advice how to use Savepoint and rollback to savepoint in function. I