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

From Oliver Elphick
Subject Re: Strange situation with two tables.
Date
Msg-id 1031753967.2067.364.camel@linda
Whole thread Raw
In response to Strange situation with two tables.  (Terry Yapt <yapt@technovell.com>)
List pgsql-novice
On Wed, 2002-09-11 at 14:34, Terry Yapt wrote:
...
> And here is the problem because more client connections are inserting
debits (and perhaps to the same customer_number I am working with), but
I _ONLY_ MUST to update the debits.bill_number to that debits.ROWS I
have treated in the bill.ROW creation step.


I think you are worrying about a non-problem..  If you are working in a
PL/PGSQL function. anything you do will automatically happen inside one
transaction.  Therefore, nothing that happens to the database after that
transaction starts will be visible to your function.  So you don't have
to worry about subsequent changes.

If you are doing several inserts before doing your bill update, and
don't want a later bill to include the ones you are dealing with,
enclose all your SQL commands in BEGIN ... END to turn them all into one
transaction.  (Don't confuse PL/PGSQL's BEGIN...END with SQL's
BEGIN...END)  None of the results of the transaction will be visible to
other connections until the transaction is 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: Kevin_Walsh@deichmann.com
Date:
Subject: real beginner's questions
Next
From: David Lloyd
Date:
Subject: Re: real beginner's questions