[HACKERS] Checksum failures generate warnings

2013-04-20 Thread Bruce Momjian
Do we really want to generate just a warning for a checksum failure, and not an error; see PageIsVerified(). -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + --

Re: [HACKERS] doc hdparm also support SATA

2013-04-20 Thread Peter Eisentraut
On Sun, 2013-04-07 at 14:29 +0800, Jov wrote: from the pg doc: http://www.postgresql.org/docs/devel/static/wal-reliability.html :On Linux, IDE drives can be queried using hdparm -I; write caching is enabled if there is a * next to Write cache. hdparm -W 0 can be used to turn off write

Re: [HACKERS] [GSOC] questions about idea rewrite pg_dump as library

2013-04-20 Thread Joel Jacobson
On Fri, Apr 12, 2013 at 1:07 PM, Hannu Krosing ha...@2ndquadrant.comwrote: I was just thinking of moving the queries the pg_dump currently uses into UDF-s, which do _not_ use catalog cache, but will use the same SQL to query catalogs as pg_dump currently does using whatever snapshot mode is

[HACKERS] Need help with TRAP: FailedAssertion(!(context != CurrentMemoryContext)

2013-04-20 Thread Stephen Woodbridge
Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in the logfile. TRAP: FailedAssertion(!(context != CurrentMemoryContext), File: mcxt.c, Line:

Re: [HACKERS] Need help with TRAP: FailedAssertion(!(context != CurrentMemoryContext)

2013-04-20 Thread Andres Freund
On 2013-04-20 16:32:36 -0400, Stephen Woodbridge wrote: Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in the logfile. TRAP:

Re: [HACKERS] Need help with TRAP: FailedAssertion(!(context != CurrentMemoryContext)

2013-04-20 Thread Stephen Woodbridge
On 4/20/2013 5:00 PM, Andres Freund wrote: On 2013-04-20 16:32:36 -0400, Stephen Woodbridge wrote: Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in

Re: [HACKERS] Need help with TRAP: FailedAssertion(!(context != CurrentMemoryContext)

2013-04-20 Thread Stephen Woodbridge
OK, it looks like there is a bug related to MinGW builds. If I remove both --enable-cassert --enable-debug from my configure then I get a build that works. Removing just --enable-cassert did not solve the problem. I did not try just removing --enable-debug only. Someone might want to look

Re: [HACKERS] Need help with TRAP: FailedAssertion(!(context != CurrentMemoryContext)

2013-04-20 Thread Tom Lane
Stephen Woodbridge wood...@swoodbridge.com writes: Thank you for your reply. The frustrating thing about this is the same source works fine in Linux. So here is the pseudo code of my source removing non pgsql stuff and not expected to be runnable: You can't hold a SPI context open across

[HACKERS] 9.3 Beta1 status report

2013-04-20 Thread Bruce Momjian
I am not sure if Tom shared yet, but we are planning to package 9.3 beta1 on April 29, with a release on May 2. Those dates might change, but that is the current plan. I have completed a draft 9.3 release notes, which you can view here: http://momjian.us/pgsql_docs/release-9-3.html I

Re: [HACKERS] 9.3 Beta1 status report

2013-04-20 Thread Peter Geoghegan
On Sat, Apr 20, 2013 at 10:02 PM, Bruce Momjian br...@momjian.us wrote: I will be working on polishing them for the next ten days, so any feedback, patches, or commits are welcome. I still need to add lots of SGML markup. I've noticed a few things: * Allow heap-only tuple updates on system

Re: [HACKERS] 9.3 Beta1 status report

2013-04-20 Thread Pavan Deolasee
On Sun, Apr 21, 2013 at 11:06 AM, Peter Geoghegan p...@heroku.com wrote: On Sat, Apr 20, 2013 at 10:02 PM, Bruce Momjian br...@momjian.us wrote: I will be working on polishing them for the next ten days, so any feedback, patches, or commits are welcome. I still need to add lots of SGML