Skip site navigation (1) Skip section navigation (2)

Re: reservation overlap constraint checking?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Aditya <aditya(at)grot(dot)org>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: reservation overlap constraint checking?
Date: 2005-05-20 18:29:11
Message-ID: 200505201129.11439.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Aditya,

> however, that seems less than elegant because there is time between the
> check and the insert for a competing entry to get inserted....so next thing
> to try is a constratint:

Use a transaction and "select for update".

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

sfpug by date

Next:From: AdityaDate: 2005-05-20 19:03:48
Subject: Re: reservation overlap constraint checking?
Previous:From: AdityaDate: 2005-05-20 16:25:08
Subject: reservation overlap constraint checking?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group