[Pgcluster-general] Non-deterministic functions/statements

At.Mitani mitani at sraw.co.jp
Fri Apr 4 01:02:07 UTC 2008


Hi Ryan,

Currently, there is no plan to support pgcrypto.
However, we might put it in the todo list after investigate it.

The Todo List that I remember is as follows,
  -- Cluster system management tools
      in order to support installation, monitoring and operation.
  -- tsearch support

Any other comments or suggestions?

Regards,
---------------------------
At.Mitani

On Thu, 3 Apr 2008 11:34:24 -0700
Ryan Hofschneider <ryan.hofschneider at ngc.com> wrote:

> Howdy:
> 
> What explicit support does pgcluster have for the various non- 
> deterministic functions in PostgreSQL? What do I have to be aware of  
> when I am replicating via the statement-based replication provided by  
> pgcluster?
> 
> I have done primitive tests with random(), now(), and  
> current_timestamp and these seem to work, even when wrapped in a  
> stored procedure.
> 
> However, I installed pgcrypto from /usr/share/pgsql/contrib/ and  
> inserts using the pgcrypto functions did not get replicated across the  
> cluster.
> 
> Thanks for your insights.
> 
> Cheers,
> Ryan
> 
> 
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general


-- 
At.Mitani <mitani at sraw.co.jp>


More information about the Pgcluster-general mailing list