Re: Strange situation with two tables. - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Strange situation with two tables.
Date
Msg-id 1031780687.2067.601.camel@linda
Whole thread Raw
In response to Re: Strange situation with two tables.  (Terry Yapt <yapt@technovell.com>)
List pgsql-novice
On Wed, 2002-09-11 at 18:20, Terry Yapt wrote:
> Ok, I must to set isolation level to 'serializable' at the function begin, and set isolation level to 'normal mode'
atthe end. 
>
> How can I do it ?

SET TRANSACTION ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "I am crucified with Christ; nevertheless I live; yet
      not I, but Christ liveth in me; and the life which I
      now live in the flesh I live by the faith of the Son
      of God, who loved me, and gave himself for me."
                                         Galatians 2:20


pgsql-novice by date:

Previous
From: "Chad Thompson"
Date:
Subject: A and C not B
Next
From: "Curtis Mortensen"
Date:
Subject: Re: pg_restore error