[Pgcluster-general] Non-deterministic functions/statements

[Ryan Hofschneider]

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