Re: Bitfields always atomic? Other way to store attributes?

From: "TJ O'Donnell" <tjo(at)acm(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <bryce1(at)obviously(dot)com>
Subject: Re: Bitfields always atomic? Other way to store attributes?
Date: 2006-03-28 21:55:01
Message-ID: 1066.209.223.166.104.1143582901.squirrel@www.gnova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> If I have two threads modifying the same "bit" field:
> thread1=> update table set bf=bf | '01000'
> thread2=> update table set bf=bf | '10000'
> Will this operation always be safe (e.g. result in bf='11000')? Or

Won't this always result in bf='11xxx', depending on the
original values of bf?

TJ
www.gnova.com

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-03-28 21:59:41 Re: Bitfields always atomic? Other way to store attributes?
Previous Message Fay Du 2006-03-28 18:33:02 Re: Update question