From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "T(dot)J(dot)Farrell" <T(dot)J(dot)Farrell(at)wanadoo(dot)fr>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL and multiple database access |
Date: | 2000-06-13 19:58:24 |
Message-ID: | 4.3.2.7.2.20000613165629.00ce7220@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You could use locking for this (as someone else suggested) but you'd
probably be better off using transactions. That way no one will get an
error, and whoever commits last will have the final say of what the record
is set to.
At 05:41 PM 6/7/00, you wrote:
>Hi,
>
>I work in an environment where people can update the PostgreSQL database
>from several sites (insert, update, delete statements).
>If two people try to update, insert or delete the same row at the same
>time, or if one deletes a row that the other is viewing and trying to
>update, in postgreSQL, what happens??
>
>I'm looking from success/failure stories, tips anything that can help me
>code consequently!
>
>TIA
>
>T.J.
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Britten | 2000-06-13 20:34:54 | permissions? |
Previous Message | Philip Hallstrom | 2000-06-13 19:23:15 | Re: triggers and functions in pgsql 7.0.2 |