| From: | Shane Wright <me(at)shanewright(dot)co(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: table locking |
| Date: | 2002-02-18 16:37:38 |
| Message-ID: | 200202181637.g1IGbfJ04987@fullerruss.dsvr.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi Tom,
Sorry I tihnk I misunderstood your post the first time round :(
SHARE ROW EXCLUSIVE MODE works just fine :)) Thanks very much :)
Regards
Shane
On Monday 18 Feb 2002 3:42 pm, Tom Lane wrote:
> I think you want just LOCK TABLE tab IN SHARE ROW EXCLUSIVE MODE
> or LOCK TABLE tab IN EXCLUSIVE MODE. The latter would lock out
> SELECT FOR UPDATE, the former wouldn't.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-02-18 18:24:16 | Re: Need to change the size of a field |
| Previous Message | Shane Wright | 2002-02-18 15:46:16 | Re: table locking |