[PATCHES] txid cleanup

2007-10-11 Thread Marko Kreen
Per Tom comments, attached patch does following: - Binary I/O support - Use ActiveSnapshot instead of SerializableSnapshot - Clarify function purposes - remove dev targets from Makefile There should not be any code depending on SerializableSnapshot, if there is thats a bug that needs fixing. Fi

[PATCHES] Patch: txid in core

2007-10-11 Thread Marko Kreen
Just in case there is initdb required in beta2, here is patch that adds txid into core. Otherwise please register this as submission to 8.4. I'd like to avoid any process related discussions in the future... It is syned with the latest patch I sent to -patches. The docs are minimal, but I think

[PATCHES] Packed varlena tuptoaster.c oops

2007-10-11 Thread Gregory Stark
Caught this in my testing with enhanced debugging checks. Index: src/backend/access/heap/tuptoaster.c === RCS file: /home/stark/src/REPOSITORY/pgsql/src/backend/access/heap/tuptoaster.c,v retrieving revision 1.77 diff -u -r1.77 tupt

Re: [PATCHES] Packed varlena tuptoaster.c oops

2007-10-11 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Caught this in my testing with enhanced debugging checks. Applied, thanks. regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating

Re: [PATCHES] [HACKERS] quote_literal with NULL

2007-10-11 Thread Brendan Jurd
Hi patchers, Per discussion on -hackers, I've implemented a new internal function quote_nullable, as an alternative to quote_literal. The difference is that quote_nullable returns the text value 'NULL' on NULL input, which is suitable for insertion into an SQL statement. The idea is that when yo

[PATCHES] Cancelling Blocking Autovacuums (patch)

2007-10-11 Thread Simon Riggs
Patch, with matching discussion thread on hackers. Test script included, not suggested for inclusion in regression tests. 2007-10-11 19:35:27 BST 2209LOG: autovacuum launcher started 2007-10-11 19:36:42 BST 2213LOG: automatic analyze of table "postgres.pg_catalog.pg_attribute" system usage: CP

Re: [PATCHES] txid cleanup

2007-10-11 Thread Tom Lane
"Marko Kreen" <[EMAIL PROTECTED]> writes: > Also - either Tom or Jan has changed the code to allow > xmin == xmax. Is such case really valid? Yes, at least in CVS HEAD. regards, tom lane ---(end of broadcast)--- TIP 5: don'

Re: [PATCHES] txid cleanup

2007-10-11 Thread Tom Lane
"Marko Kreen" <[EMAIL PROTECTED]> writes: > Per Tom comments, attached patch does following: > - Binary I/O support > - Use ActiveSnapshot instead of SerializableSnapshot > - Clarify function purposes > - remove dev targets from Makefile Applied with some further editorialization.

Re: [PATCHES] txid cleanup

2007-10-11 Thread Marko Kreen
On 10/11/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Marko Kreen" <[EMAIL PROTECTED]> writes: > > Also - either Tom or Jan has changed the code to allow > > xmin == xmax. Is such case really valid? > > Yes, at least in CVS HEAD. Aha, I had missed that. Thanks for confirmation. -- marko ---

Re: [PATCHES] [HACKERS] quote_literal with NULL

2007-10-11 Thread Simon Riggs
On Fri, 2007-10-12 at 02:11 +1000, Brendan Jurd wrote: > Per discussion on -hackers, I've implemented a new internal function > quote_nullable, as an alternative to quote_literal. The difference is > that quote_nullable returns the text value 'NULL' on NULL input, which > is suitable for insertio