Re: [SQL] how can I mirror a postgres database

2000-09-30 Thread Philip Warner
7.1 will have replication curtesy of PostgreSQL Inc: http://www.pgsql.com/press/Pgsql_Inc_Press-5.pdf (it is being freely donated to the source tree, according to their statement) Philip Warner| __---_

[SQL] how can I mirror a postgres database

2000-09-30 Thread Dronamraju Rajesh
Hi all, I am having postgres6.5 installed on a remote linux server. Now i have installed the same scenario in a local machine. Now i want to update my local machine with any transaction or changes made in remote machine. something like a oracle parallel server. where if one machine breaks dow

Re: [SQL] Transaction isolation level for plpgsql

2000-09-30 Thread Peter Eisentraut
Keith Wong writes: > Does anybody know the transaction isolation level default when a plpgsql > stored procedure is called? > Is it possible to set it? Or is this controlled by SPI? It's whatever the transaction that called the function was set to. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [SQL] Transaction isolation level for plpgsql

2000-09-30 Thread Poul L. Christiansen
Use the command "\h set" and you'll see the parameters. test=# \h set Command: SET Description: Set run-time parameters for session Syntax: SET variable { TO | = } { value | 'value' | DEFAULT } SET CONSTRAINTS {ALL | constraintlist} mode SET TIME ZONE { 'timezone' | LOCAL | DEFAULT } SET TRAN