[HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Greg Smith
I'm behind on my list mail so maybe this has been mentioned already, but when I just tried pg_stat_bgwriter from a build against today's HEAD I got this: pgbench=# select count(*) FROM pg_stat_bgwriter; ERROR: did not find '}' at end of input node Can someone confirm if this broke recently,

Re: [HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: I'm behind on my list mail so maybe this has been mentioned already, but when I just tried pg_stat_bgwriter from a build against today's HEAD I got this: pgbench=# select count(*) FROM pg_stat_bgwriter; ERROR: did not find '}' at end of input node

Re: [HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Greg Smith
Tom Lane wrote: Worksforme. You probably need a full recompile and/or initdb Yeah, sorry about the noise. This went away after some more intensive rebuilding. I think I still want to add some regression testing of this view as suggested. If that had been there, I'd have been a lot more

Re: [HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: Tom Lane wrote: Worksforme. You probably need a full recompile and/or initdb Yeah, sorry about the noise. This went away after some more intensive rebuilding. I think I still want to add some regression testing of this view as suggested. If that

Re: [HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Greg Smith
Tom Lane wrote: If the cause was what I suggested, most likely the other stats views were broken too --- were you able to pass the regression tests in that state? I was having a lot of problems with the system that included regression test issues, and yelped about this one earlier than I

Re: [HACKERS] pg_stat_bgwriter broken?

2010-11-14 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: The way you've explained it now, I see why it's not worth adding a specific regression test for this in the future, and what else I should have checked when I ran into my problem (that other system stats views were also working or not). FWIW, I