Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2012-08-24 Thread Alvaro Herrera
Excerpts from Robert Haas's message of sáb ago 25 00:10:57 -0400 2012: > > It looks sane to me in a quick once-over (bearing in mind I can't test > > it). What's bothering you about the ereport calls? > > Well, 9.1 currently has: > > errmsg_internal("failed to enumerate network events: %i", (in

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2012-08-24 Thread Robert Haas
On Wed, Aug 22, 2012 at 10:24 PM, Tom Lane wrote: > Robert Haas writes: >> On Tue, Aug 21, 2012 at 4:30 PM, Tom Lane wrote: >>> Meanwhile, back at the ranch: I'm fine with applying that patch now that >>> it's had some field testing. > >> Attached is a version that applies OK to 9.1, after resol

Re: [BUGS] Minor inheritance/check bug: Inconsistent behavior

2012-08-24 Thread Amit Kapila
From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, August 24, 2012 7:46 PM Amit Kapila writes: > From: pgsql-bugs-ow...@postgresql.org > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane >>> None of the system columns are set at the time check constraints are >>> checked. >> I

Re: [BUGS] Minor inheritance/check bug: Inconsistent behavior

2012-08-24 Thread Tom Lane
Chris Travers writes: > Table inheritance would be easier if there was a way to declare a > constraint such that it prevents insert for some rows on the parent > but not for a child and/or vice versa. FWIW, 9.2 adds support for constraints that only apply to the named table and don't get inherite

Re: [BUGS] BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"

2012-08-24 Thread Euler Taveira
On 24-08-2012 00:16, she...@163.net wrote: > Maybe this is a bug. > if stats collector process don't product pg_stat_tmp/pgstat.stat file, the > autovacuum launcher process will output those WARNING message? > It is possible but... Did you see any ERROR message(s) related to statistics collector b

Re: [BUGS] Minor inheritance/check bug: Inconsistent behavior

2012-08-24 Thread Chris Travers
On Fri, Aug 24, 2012 at 3:52 AM, Amit Kapila wrote: > From: pgsql-bugs-ow...@postgresql.org > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane > Sent: Friday, August 24, 2012 10:33 AM > Chris Travers writes: >>> My guess is that tableoid is not known when the check constraint is >>>

Re: [BUGS] Minor inheritance/check bug: Inconsistent behavior

2012-08-24 Thread Tom Lane
Amit Kapila writes: > From: pgsql-bugs-ow...@postgresql.org > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane >> None of the system columns are set at the time check constraints are >> checked. > Is there any problem if set tableOID before calling ExecConstarints()? Well, possibly

Re: [BUGS] Minor inheritance/check bug: Inconsistent behavior

2012-08-24 Thread Amit Kapila
From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Friday, August 24, 2012 10:33 AM Chris Travers writes: >> My guess is that tableoid is not known when the check constraint is >> checked. >None of the system columns are set at the time chec