From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>,
Chris Campbell <chris(at)bignerdranch(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject:
Re: [HACKERS] Deadlock with pg_dump?
Date:
2007-03-01 19:17:20
Message-ID:
12779.1172776640@sss.pgh.pa.us (view raw or flat )
Thread:
2006-10-26 20:45:02 from Chris Campbell <chris(at)bignerdranch(dot)com>
2006-10-26 21:21:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-26 22:11:59 from Chris Campbell <chris(at)bignerdranch(dot)com>
2006-10-26 22:29:11 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-10-26 22:45:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-10-26 23:23:12 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-10-27 00:27:31 from Chris Campbell <chris(at)bignerdranch(dot)com>
2006-10-30 20:49:57 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-14 03:19:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-19 19:38:41 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-19 22:29:40 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 18:34:01 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-26 19:01:24 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 19:11:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-26 19:19:49 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 19:28:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-26 19:31:49 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 19:52:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-26 20:05:07 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 20:10:49 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-26 20:15:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 02:06:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-01 05:45:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 14:06:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-01 19:17:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 18:35:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-02 18:51:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 20:20:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-02 20:55:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 22:05:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-02 22:37:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 22:46:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-02 23:38:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-03 02:40:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-03 02:43:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-03 18:49:32 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-11-21 04:40:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers pgsql-patches
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> What are *you* thinking? Yes, that patch has that line, but
> log_statement and log_min_duration_statement is going to trigger
> log_min_error_statement so you are going to get the statement printed
> twice.
What's wrong with that? If a statement triggers two different log
entries, and both are subject to being annotated with the statement text
according to log_min_error_statement, I would expect them both to be
annotated. Doing otherwise will probably break automated log analysis
tools.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Magnus HaganderDate: 2007-03-01 19:30:25Subject : Removing some of the old VC++ stuffPrevious :From : Martijn van OosterhoutDate : 2007-03-01 18:47:56Subject : Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock?
pgsql-patches by date
Next :From: Heikki LinnakangasDate: 2007-03-01 20:13:54Subject : Re: A little COPY speedupPrevious :From : Tom LaneDate : 2007-03-01 19:05:31Subject : Re: A little COPY speedup
