Re: [HACKERS] Scanning for insert

2006-02-27 Thread James William Pye
On Mon, Feb 27, 2006 at 05:44:20PM -0500, Tom Lane wrote: > Is this really a good idea? The fundamental problem I see with it is > that it takes away the index AM's ability to make any guarantees about > its locking behavior, ie, how long locks will be held or what other > operations might interve

Re: [HACKERS] Scanning for insert

2006-02-27 Thread Tom Lane
James William Pye <[EMAIL PROTECTED]> writes: > The attached patch extends pg_am by adding two methods, "scan for insert" and > "insert from scan". These methods are meant to provide an index user with the > ability to do conditional insertions based on the results of a conclusive > locking scan--a

[HACKERS] Scanning for insert

2006-02-27 Thread James William Pye
Greets, [Ugh, sent one with uncompressed patch. Seems to be swallowed(No failure msg?). Ignore it if it surfaces.] The attached patch extends pg_am by adding two methods, "scan for insert" and "insert from scan". These methods are meant to provide an index user with the ability to do conditional