Re: getting duplicate number is there a

Поиск
Список
Период
Сортировка
От Ezequiel Tolnay
Тема Re: getting duplicate number is there a
Дата
Msg-id d6btqq$24v7$1@news.hub.org
обсуждение исходный текст
Ответ на getting duplicate number is there a  ("Joel Fradkin" <jfradkin@wazagua.com>)
Список pgsql-sql
You can select "for update", so you ensure that the rows are locked for 
your current transaction's use exclusively. If the rows in question had 
been modified by another ongoing transaction, then the select will get 
blocked until the other transaction is finished.

Cheers,

Ezequiel Tolnay
etolnay@gbtech.com.au

Joel Fradkin wrote:
> I was using SET TRANSACTION ISOLATION LEVEL SERIALIZABLE in MSSQL.
> 
> Is there something similar in postgres to ensure its not in the middle 
> of being updated?
> 
>             sql = "SELECT COUNT(*) FROM tblcase WHERE LocationID = " & 
> intLocationID & _
> 
>                   " and substr(casenum,length(casenum)-1,2) = '" & 
> right(year(date),2) & "' AND clientnum = '" & _
> 
>                   chrClientNum & "'"
> 
> I will add a select just before doing the insert to see if this helps, 
> its not happening a bunch, but 5 6 times a day is still an issue for me.
> 
> I use the count as a segment of my case number so each time a new case 
> is entered the count goes up for that location for that year.
> 
> Joel Fradkin


В списке pgsql-sql по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?
Следующее
От: "Sim Zacks"
Дата:
Сообщение: plpython setof