Re: [SQL] Transaction isolation level for plpgsql

[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 TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }

test=# show transaction isolation level;
NOTICE:  TRANSACTION ISOLATION LEVEL is READ COMMITTED
SHOW VARIABLE
test=#

HTH,
Poul L. Christiansen


Keith Wong wrote:
> 
> Hi all,
> 
> 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?
> 
> Cheers,
> Keith.

Re: [SQL] Transaction isolation level for plpgsql

[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]   http://yi.org/peter-e/

[SQL] how can I mirror a postgres database

[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 down due to some reason
the other machine can take over as it has all the data
with it.

  I want to move my complete database with critical
data on to postgres. can anybody please suggest how do
i do it as the server is a mission critical server. 

  any suggestions are appreciated and thanks for all
of the suggestions in advance.

Thanks & Regards
Rajesh.

__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

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

[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| __---_
Albatross Consulting Pty. Ltd.   |/   -  \
(A.B.N. 75 008 659 498)  |  /(@)   __---_
Tel: (+61) 0500 83 82 81 | _  \
Fax: (+61) 0500 83 82 82 | ___ |
Http://www.rhyme.com.au  |/   \|
 |----
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/