why can't select for update be used with join

From:	Kris Kiger <kris(at)musicrebellion(dot)com>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	why can't select for update be used with join
Date:	2003-11-05 19:17:48
Message-ID:	3FA94CDC.1090309@musicrebellion.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2003-10-31 10:04:08 from Marek Florianczyk <franki(at)tpi(dot)pl>  2003-10-31 10:52:07 from "Matt Clark" <matt(at)ymogen(dot)net>   2003-10-31 11:08:08 from Marek Florianczyk <franki(at)tpi(dot)pl>    2003-10-31 11:25:21 from "Matt Clark" <matt(at)ymogen(dot)net>     2003-10-31 12:14:12 from Marek Florianczyk <franki(at)tpi(dot)pl>      2003-10-31 12:33:12 from "Matt Clark" <matt(at)ymogen(dot)net>       2003-10-31 12:35:30 from Marek Florianczyk <franki(at)tpi(dot)pl>       2003-10-31 12:54:33 from Jamie Lawrence <postgres(at)jal(dot)org>        2003-10-31 13:20:09 from Marek Florianczyk <franki(at)tpi(dot)pl>         2003-10-31 14:30:57 from "Matt Clark" <matt(at)ymogen(dot)net>          2003-10-31 15:16:06 from Marek Florianczyk <franki(at)tpi(dot)pl>  2003-10-31 12:06:58 from Gaetano Mendola <mendola(at)bigfoot(dot)com>   2003-10-31 12:31:34 from Marek Florianczyk <franki(at)tpi(dot)pl>  2003-10-31 14:23:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2003-11-05 13:33:33 from Marek Florianczyk <franki(at)tpi(dot)pl>    2003-11-05 13:48:52 from Jeff <threshar(at)torgo(dot)978(dot)org>     2003-11-05 15:14:59 from Marek Florianczyk <franki(at)tpi(dot)pl>      2003-11-05 16:18:27 from Bruno Wolff III <bruno(at)wolff(dot)to>       2003-11-05 18:01:38 from Marek Florianczyk <franki(at)tpi(dot)pl>        2003-11-05 18:23:49 from Jeff <threshar(at)torgo(dot)978(dot)org>         2003-11-05 18:23:36 from Marek Florianczyk <franki(at)tpi(dot)pl>     2003-11-05 16:24:07 from Andrew Sullivan <andrew(at)libertyrms(dot)info>      2003-11-05 16:44:28 from Marek Florianczyk <franki(at)tpi(dot)pl>    2003-11-05 17:59:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2003-11-05 18:19:39 from Marek Florianczyk <franki(at)tpi(dot)pl>      2003-11-05 18:34:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2003-11-05 18:30:55 from Marek Florianczyk <franki(at)tpi(dot)pl>        2003-11-05 18:52:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2003-11-05 18:55:50 from Marek Florianczyk <franki(at)tpi(dot)pl>          2003-11-05 19:17:48 from Kris Kiger <kris(at)musicrebellion(dot)com>           2003-11-05 21:13:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2003-11-05 21:05:49 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>           2003-11-06 14:21:03 from Marek Florianczyk <franki(at)tpi(dot)pl>            2003-11-06 14:37:25 from Jeff <threshar(at)torgo(dot)978(dot)org>             2003-11-06 14:38:43 from Marek Florianczyk <franki(at)tpi(dot)pl>              2003-11-06 15:17:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2003-11-06 15:07:57 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>              2003-11-06 17:23:57 from William Yu <wyu(at)talisys(dot)com>               2003-11-10 15:29:00 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>             2003-11-06 15:40:40 from Christopher Browne <cbbrowne(at)libertyrms(dot)info>              2003-11-07 09:27:23 from CoL <col(at)mportal(dot)hu>              2003-11-08 20:38:24 from Stephen Frost <sfrost(at)snowman(dot)net>               2003-11-09 00:02:23 from Christopher Browne <cbbrowne(at)acm(dot)org>            2003-11-06 17:24:17 from "David Green" <david(at)sagerobot(dot)com>             2003-11-06 18:39:57 from Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>            2003-11-06 17:26:54 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>  2003-10-31 18:48:12 from "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Lists:	pgsql-admin

In response to

• Re: performance problem - 10.000 databases at 2003-11-05 18:55:50 from Marek Florianczyk

Responses

• Re: why can't select for update be used with join at 2003-11-05 21:13:41 from Tom Lane

Browse pgsql-admin by date

	From	Date	Subject
Next Message	scott.marlowe	2003-11-05 21:05:49	Re: performance problem - 10.000 databases
Previous Message	Marek Florianczyk	2003-11-05 18:55:50	Re: performance problem - 10.000 databases