From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SELECT FOR UPDATE locks whole table |
Date: | 2002-12-06 19:10:46 |
Message-ID: | 200212061910.gB6JAkY06339@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
It should lock only the rows you retrieved, but I have no idea how FOR
UPDATE and INTO TEMP behave. My guess is that it should work fine, but
I have never seen those two used together before.
---------------------------------------------------------------------------
D'Arcy J.M. Cain wrote:
> We have the following query:
>
> SELECT certificate_id
> INTO TEMP TABLE x_certs
> FROM certificate
> WHERE cert_status = 0 AND
> certificate_id BETWEEN 1111 AND 2222 AND
> client_id IN (1, 2, 3)
> ORDER BY certificate_id
> FOR UPDATE;
>
> Is there any reason that this query should lock the entire certificate table?
> Is there something strange because of the IN clause or because it is going
> into a temporary table? This is a production server running 7.2.2 so perhaps
> it is fixed in 7.3.
>
> --
> D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
> http://www.druid.net/darcy/ | and a sheep voting on
> +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-06 19:38:50 | Re: SQL/MED spec for cross-database linkages |
Previous Message | D'Arcy J.M. Cain | 2002-12-06 19:03:02 | SELECT FOR UPDATE locks whole table |
From | Date | Subject | |
---|---|---|---|
Next Message | Cédric Dufour (public) | 2002-12-06 20:33:10 | Re: Accent-insensitive |
Previous Message | D'Arcy J.M. Cain | 2002-12-06 19:03:02 | SELECT FOR UPDATE locks whole table |