PgSql

double and numeric conversion
Theo Schlossnagle wrote: Hello all, I'm writing some extension and I have a hot code path that has a lot of double (C type) data and needs to output NUMERIC tuple data. The current methods I can find in the code to convert sprintf the double to a buffer and then invoke the numeric_in function on them. I'... 3 Mar 2010 16:25

Plans for 9.1, Grouping Sets, disablingmultiqueries, contrib module for string, plpgpsm, preload dictionaries
On sön, 2010-02-21 at 11:00 +0100, Pavel Stehule wrote: * Now I am working on migration of plpgpsm to plpgsql 9.0 base. I hope so I understand SQL/PSM well so I am able to write production quality implementation. If you like, I can integrate it to core. It can share about 40-50% code with plpgpsm. The behav... 1 Mar 2010 15:18

[HACKERS] USE_LIBXSLT in MSVC builds
BTW, it looks like the MSVC build scripts don't bother to make sure that USE_LIBXSLT is defined (or not) correctly --- at least I can't see any reference to that symbol in the Windows-specific files. This is now necessary to avoid disabling the xslt functionality in contrib/xml2. I'm not too sure what to poke ther... 1 Mar 2010 15:18

[HACKERS] contrib/xml2 regression tests vs no-libxslt build option
In yet another demonstration that no good deed goes unpunished, I see that my addition of regression tests to contrib/xml2 is still a few bricks shy of a load. Buildfarm member pika is failing on it, and the reason is clear upon inspection: pika is configured --with-libxml but not --with-libxslt, so the xslt_proce... 1 Mar 2010 11:24

pgsql: add EPERM to the list of return codes to expect from opening
This isn't working. The Windows ports are all saying "permission denied" but apparently that's not because errno is set to EPERM. Anyone know how to detect "permission denied" errors from open() on windows? On Mon, Mar 1, 2010 at 12:04 AM, Greg Stark <stark(a)postgresql.org> wrote: Log Message: ----------- ... 1 Mar 2010 12:32

[HACKERS] Could we do pgindent on just utils/adt/xml.c in the 8.3 branch?
I just committed a backpatch of http://archives.postgresql.org/pgsql-committers/2009-05/msg00229.php to 8.3. As in that patch, I did not try to manually reindent the code that's now wrapped in PG_TRY blocks. It might be a good idea to run pgindent on just that one file so that it's spacing-consistent with the la... 28 Feb 2010 22:16

contrib/xml2 vs core xml in 8.3
On Sun, Feb 28, 2010 at 06:57:33PM -0500, Tom Lane wrote: So I started to work on back-patching the no-pallocs change in xml2. It seems to work fine in 8.4, but it crashes in 8.3. The reason is that we never back-patched the 8.4 change to make utils/adt/xml.c not change the libxml2 memory allocation functi... 28 Feb 2010 20:03

contrib/xml2 pfree bug
Andrew Dunstan <andrew(a)dunslane.net> writes: Didn't we just clean up a mess in our XML handling to do with memory handlers? It looks like contrib/xml2 might have similar problems. BTW, I couldn't duplicate this because I don't know what cb_ob_invoice_xml(1,1) refers to. Can you provide a self-contained exa... 28 Feb 2010 16:43

[GENERAL] trouble with to_char('L')
Hiroshi Inoue wrote: Bruce Momjian wrote: Hiroshi Inoue wrote: Bruce Momjian wrote: Where are we on this issue? Oops I forgot it completely. I have a little improved version and would post it tonight. Ah, very good. Thanks. Attached is an improved version. I spent ... 26 Apr 2010 10:15

Performance Patches Was: [HACKERS] Lock Wait Statistics (next commitfest)
Greg Smith wrote: While I was in there I also added some more notes on my personal top patch submission peeve, patches whose purpose in life is to improve performance that don't come with associated easy to run test cases, including a sample of that test running on a system that shows the speed... 27 Feb 2010 20:59