Re: [PATCHES] COPY LOCK for WAL bypass

2005-12-21 Thread Bruce Momjian
Simon Riggs wrote: On Sun, 2005-12-18 at 22:03 -0500, Chris Browne wrote: [EMAIL PROTECTED] (Simon Riggs) writes: On Sat, 2005-12-10 at 12:07 +, Simon Riggs wrote: Following patch implements COPY ... FROM ... LOCK Patch now updated so that it includes an additional optimization

Re: [PATCHES] COPY LOCK for WAL bypass

2005-12-21 Thread Bruce Momjian
Jim C. Nasby wrote: On Mon, Dec 19, 2005 at 07:51:54AM +, Simon Riggs wrote: On Sun, 2005-12-18 at 22:03 -0500, Chris Browne wrote: [EMAIL PROTECTED] (Simon Riggs) writes: On Sat, 2005-12-10 at 12:07 +, Simon Riggs wrote: Following patch implements COPY ... FROM ... LOCK

Re: [PATCHES] [GENERAL] Converting seconds past midnight to a time

2005-12-21 Thread Bruce Momjian
Tom Lane wrote: Karl O. Pinc [EMAIL PROTECTED] writes: What is the best way to convert an integer number of seconds past midnight into a time? Intermediate 'interval' value seems to work: regression=# select (99.44 * '1 second'::interval)::time; time -

Re: [PATCHES] COPY LOCK for WAL bypass

2005-12-21 Thread Simon Riggs
On Wed, 2005-12-21 at 08:18 -0500, Bruce Momjian wrote: Jim C. Nasby wrote: On Mon, Dec 19, 2005 at 07:51:54AM +, Simon Riggs wrote: On Sun, 2005-12-18 at 22:03 -0500, Chris Browne wrote: [EMAIL PROTECTED] (Simon Riggs) writes: On Sat, 2005-12-10 at 12:07 +, Simon Riggs

Re: [PATCHES] COPY LOCK for WAL bypass

2005-12-21 Thread Simon Riggs
On Wed, 2005-12-21 at 16:23 +, Simon Riggs wrote: Writing docs now. Here's the docs... Hopefully that explains everything a little betterbut this doc patch contains a ref to the as yet unapplied --single-transaction patch, but also explains why that patch exists also. [Patch via

Re: [PATCHES] COPY LOCK for WAL bypass

2005-12-21 Thread Bruce Momjian
Simon Riggs wrote: Right, just disable with a clear error message. Forgive me if my earlier reply was not clear: This patch works just the same way CREATE INDEX and CREATE TABLE AS SELECT already works: - if the server has archive_command set, WAL is written - if archive_command is not

Re: [PATCHES] [BUGS] BUG #2120: Crash when doing UTF8-ISO_8859_8 encoding conversion

2005-12-21 Thread Bruce Momjian
Tom Lane wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: It looks like somebody rearranged the pg_enc enum without bothering to fix the tables that are affected by this. I will look into this. Thank you. It might be worth adding a comment to pg_wchar.h listing all the places that need