Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Atomicity?
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
- Cc: Naz Gassiep <naz(at)mira(dot)net>, Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Atomicity?
- Date: Mon, 28 Aug 2006 22:52:44 +0200
- Message-id: <200608282252(dot)45608(dot)peter_e(at)gmx(dot)net>
Martijn van Oosterhout wrote: > Sure, UNIQUE constraints are not deferrable. With normal constraints > you can defer the check until the end of transaction and be in an > inconsistant state for while. However, PostgreSQL doesn't support > this for uniqueness checks. Note that even a nondeferred unique constraint would let the command proceed because a nondeferred constraint is checked after the statement, not at seemingly random points during it. -- Peter Eisentraut http://developer.postgresql.org/~petere/
- References:
- Atomicity?
- From: Naz Gassiep
- Re: Atomicity?
- From: Naz Gassiep
- Re: Atomicity?
- From: Martijn van Oosterhout
- Atomicity?
- Prev by Date: Re: Atomicity?
- Next by Date: Re: Postgresql mentioned on Newsforge MySQL article
- Previous by thread: Re: Atomicity?
- Next by thread: Re: Atomicity?
- Indexes: