PgSql
in [SQL]
|
[HACKERS] [PATCH] Add _PG_init to PL language handler documentation Howdy, This tiny doc patch adds _PG_init to the skeleton example code for a PL. The information is quite valuable to PL authors, who might miss it when it is described in the shared library documentation. This patch was based off of 6e2ba96 in the git mirror and a colorized diff can be viewed here: http://g... 25 May 2010 13:32
[PATCH] Add XMLEXISTS function from the SQL/XML standard On Tue, May 25, 2010 at 12:04 PM, Mike Fowler <mike(a)mlfowler.com> wrote: Erik Rijkers wrote: libxml2.x86_64 2.6.26-2.1.2.8 installed libxml2-devel.x86_64 2.6.26-2.1.2.8 installed Thanks for testing my patch Erik. It turns out I've got libxml2 installed at version 2.7.5. Searchi... 27 May 2010 07:04
recovery getting interrupted is not so unusual as itused to be On Tue, 2010-05-25 at 19:12 +0900, Fujii Masao wrote: On Mon, May 17, 2010 at 5:33 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Sat, May 15, 2010 at 3:20 AM, Robert Haas <robertmhaas(a)gmail.com> wrote: Hmm, OK, I think that makes sense. Would you care to propose a patch? Yep. Here is the pa... 25 May 2010 13:32
[PATCH] Add XMLEXISTS function from the SQL/XML standard Erik Rijkers wrote: libxml2.x86_64 2.6.26-2.1.2.8 installed libxml2-devel.x86_64 2.6.26-2.1.2.8 installed Thanks for testing my patch Erik. It turns out I've got libxml2 installed at version 2.7.5. Searching the gnome mailing lists, it turns out xmlXPathCompiledEvalToBoolean was added (... 25 May 2010 12:26
[PATCH] Add XMLEXISTS function from the SQL/XML standard (was: Add xpath_exists Function) On Tue, May 25, 2010 16:31, Mike Fowler wrote: I've been reading the SQL/XML standard and discovered that it defines a function named XMLEXISTS that does exactly what the todo item xpath_exists defines. My original patch named the function as per the todo but I think using the function name from the standar... 25 May 2010 12:26
Clearing psql`s input buffer after auto-reconnect -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 3. Have CheckConnection do longjmp(sigint_interrupt_jmp) after resetting .... Now #1 might be the best long-term solution but I have no particular appetite to tackle it, and #2 is just too ugly to contemplate. That leaves #3, which is a bit ugly in... 25 May 2010 11:19
[HACKERS] [PATCH] Add XMLEXISTS function from the SQL/XML standard (was: Addxpath_exists Function) I've been reading the SQL/XML standard and discovered that it defines a function named XMLEXISTS that does exactly what the todo item xpath_exists defines. My original patch named the function as per the todo but I think using the function name from the standard is a better idea. So this patch is the same as be... 25 May 2010 11:19
libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT ,--- I/Alex (Mon, 24 May 2010 12:25:18 -0400) ----* | No equivalent of FETCH_COUNT is available at the libpq level, so I | assume that the interface I am using is smart enough not to send | gigabytes of data to FE. | | Where does the result set (GBs of data) reside after I call | PQexecPrepared? On BE, I hope? ... 26 May 2010 10:15
[HACKERS] Hot Standby performance and deadlocking Some performance problems have been reported on HS from two users: Erik and Stefan. The characteristics of those issues have been that performance is * sporadically reduced, though mostly runs at full speed * context switch storms reported as being associated So we're looking for something that doesn't alway... 25 May 2010 06:56
ROLLBACK TO SAVEPOINT On May 25, 2010, at 6:08 , Sam Vilain wrote: http://www.postgresql.org/docs/8.4/static/sql-savepoint.html Lead us to believe that if you roll back to the same savepoint name twice in a row, that you might start walking back through the savepoints. I guess I missed the note on ROLLBACK TO SAVEPOINT that... 27 May 2010 02:45 |