Re: [PATCHES] Numeric patch to add special-case representations for < 8 bytes

2007-02-28 Thread Patric Bechtel
Michael Glaesemann schrieb am 01.03.2007 12:41: > > On Mar 1, 2007, at 12:32 , Patric Bechtel wrote: > >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Gregory Stark schrieb am 01.03.2007 10:23: >>> "Patric Bechtel" <[EMAIL PROTECTED]> writes: >>> Maybe you want to have a look here: >

Re: [PATCHES] [HACKERS] Deadlock with pg_dump?

2007-02-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I have coded up the following patch which places LOG just above ERROR in > log_min_error_statement. LOG_NO_STATEMENT? What *are* you thinking? The kindest word I can find for this is "baroque". What I had in mind was a one-line patch: if (eda

Re: [PATCHES] Numeric patch to add special-case representations for < 8 bytes

2007-02-28 Thread Michael Glaesemann
On Mar 1, 2007, at 12:32 , Patric Bechtel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gregory Stark schrieb am 01.03.2007 10:23: "Patric Bechtel" <[EMAIL PROTECTED]> writes: Maybe you want to have a look here: http://www2.hursley.ibm.com/decimal/DPDecimal.html Speaking of decimal

Re: [PATCHES] lo_truncate

2007-02-28 Thread Kris Jurka
On Wed, 28 Feb 2007, Bruce Momjian wrote: Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. Here's a patch that works with

Re: [PATCHES] Numeric patch to add special-case representations for < 8 bytes

2007-02-28 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gregory Stark schrieb am 01.03.2007 10:23: > "Patric Bechtel" <[EMAIL PROTECTED]> writes: > >> Maybe you want to have a look here: >> http://www2.hursley.ibm.com/decimal/DPDecimal.html > > Well we're not really looking for the optimal packing in genera

Re: [PATCHES] Numeric patch to add special-case representations for < 8 bytes

2007-02-28 Thread Gregory Stark
"Patric Bechtel" <[EMAIL PROTECTED]> writes: > Maybe you want to have a look here: > http://www2.hursley.ibm.com/decimal/DPDecimal.html Well we're not really looking for the optimal packing in general. All the problems here have to do with convenience in the implementation rather than the proble

Re: [PATCHES] xpath_array with namespaces support

2007-02-28 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ni

Re: [PATCHES] lo_truncate

2007-02-28 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Kr

Re: [PATCHES] Fast COPY after TRUNCATE bug and fix

2007-02-28 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Si

Re: [PATCHES] Split _bt_insertonpg to two functions

2007-02-28 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] [HACKERS] Deadlock with pg_dump?

2007-02-28 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > This is not the first GUC that has needed this. > > Exactly. I think that we simply made a mistake in the initial > implementation of log_min_error_statement: we failed to think about > whether it should use client or server priority

Re: [PATCHES] Numeric patch to add special-case representations for < 8 bytes

2007-02-28 Thread Patric Bechtel
Gregory Stark schrieb am 27.02.2007 01:39: > I've uploaded a quick hack to store numerics in < 8 bytes when possible. > > http://community.enterprisedb.com/numeric-hack-1.patch > > This is a bit of a kludge since it doesn't actually provide any interface for > external clients of the numeric modu

Re: [PATCHES] [pgsql-patches] pg_get_domaindef

2007-02-28 Thread FAST PostgreSQL
On Wed, 21 Feb 2007 09:10, Bruce Momjian wrote: Hi, Following up this patch with a contribution statement. 'With permission from the Managing Director, Fujitsu Australia Software Technology, I am granting the PostgreSQL Global Development Group the non-revokable right to distribute the source

Re: [HACKERS] [PATCHES]

2007-02-28 Thread Joshua D. Drake
FAST PostgreSQL wrote: > On Thu, 1 Mar 2007 04:28, Bruce Momjian wrote: >> I have added this to the developer's FAQ to clarify the situtation of >> posting a patch: >> >> PostgreSQL is licensed under a BSD license. By posting a patch >> to the public PostgreSQL mailling lists, you are givi

Re: [HACKERS] [PATCHES]

2007-02-28 Thread FAST PostgreSQL
On Thu, 1 Mar 2007 04:28, Bruce Momjian wrote: > I have added this to the developer's FAQ to clarify the situtation of > posting a patch: > > PostgreSQL is licensed under a BSD license. By posting a patch > to the public PostgreSQL mailling lists, you are giving the PostgreSQL > Global

Re: [PATCHES] POSIX Shared memory, revised, again

2007-02-28 Thread Chris Marcellino
Messages with PDF's seem to be dropped as Magnus described yesterday. It is in this tarball though: http://homepage.mac.com/cmarcellino/postgres-posix-shmem.tar As Tom has said a few times, there is an issue with the need to keep two different lifecycles of postmasters and backends out of the

Re: [HACKERS] [PATCHES]

2007-02-28 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Joshua D. Drake wrote: >> We should add this to the mailing list signup pages and the welcome >> pages to the lists. > Yep, good idea. Marc? For -patches and -hackers, I agree. It seems a bit legalistic and off-putting for the general lists, though.

Re: [HACKERS] [PATCHES]

2007-02-28 Thread Joshua D. Drake
Bruce Momjian wrote: > I have added this to the developer's FAQ to clarify the situtation of > posting a patch: > > PostgreSQL is licensed under a BSD license. By posting a patch > to the public PostgreSQL mailling lists, you are giving the PostgreSQL > Global Development Group the no

Re: [HACKERS] [PATCHES]

2007-02-28 Thread Bruce Momjian
Joshua D. Drake wrote: > Bruce Momjian wrote: > > I have added this to the developer's FAQ to clarify the situtation of > > posting a patch: > > > > PostgreSQL is licensed under a BSD license. By posting a patch > > to the public PostgreSQL mailling lists, you are giving the PostgreSQL >

Re: [HACKERS] [PATCHES]

2007-02-28 Thread Bruce Momjian
I have added this to the developer's FAQ to clarify the situtation of posting a patch: PostgreSQL is licensed under a BSD license. By posting a patch to the public PostgreSQL mailling lists, you are giving the PostgreSQL Global Development Group the non-revokable right to distribute

Re: [PATCHES] POSIX Shared memory, revised, again

2007-02-28 Thread David Fetter
On Tue, Feb 27, 2007 at 11:17:44AM -0800, Chris Marcellino wrote: > So I've finished reformulating this patch to use the device/inode > instead of the hash idea I had earlier. > > I have tested this patch (on Darwin) to permit the postmaster to > recover after a crash or killing, and it will not p

Re: [PATCHES] I want to omit the fopen message of Windows.

2007-02-28 Thread Magnus Hagander
On Wed, Feb 28, 2007 at 09:04:58AM +0100, Magnus Hagander wrote: > On Wed, Feb 28, 2007 at 02:20:01AM -0500, Tom Lane wrote: > > "Hiroshi Saito" <[EMAIL PROTECTED]> writes: > > > Is this message necessary for setting errno again? > > > > AFAIR we only intended that message as a temporary measure u

[PATCHES] Updated Packed Varlena (relative to CVS post SET_VARSIZE changes)

2007-02-28 Thread Gregory Stark
I've updated the patch against Tom's recent commit of the SET_VARSIZE changes. It's about 40% the size it was before, most of the remaining patch is actually heaptuple.c and tuptoaster.c which is the key code. http://community.enterprisedb.com/varlena/patch-varvarlena-13.patch.gz I had fixed mo

Re: [HACKERS] [PATCHES]

2007-02-28 Thread korryd
> > Not that I think that anyone owning both a law degree and a computer > > in 2007 should legitimately be able to plead innocence here. FAST > > Australia's lawyers are making themselves look like idiots, and the > > same for every other company tacking on such notices. I think the > > real bot

Re: [PATCHES] Final version of IDENTITY/GENERATED patch

2007-02-28 Thread Zoltan Boszormenyi
Hi, I think now this is really the final version. Changes in this version is: - when dropping a column that's referenced by a GENERATED column, the GENERATED column has to be also dropped. It's required by SQL:2003. - COPY table FROM works correctly with IDENTITY and GENERATED columns - ext

Re: [PATCHES] I want to omit the fopen message of Windows.

2007-02-28 Thread Magnus Hagander
On Wed, Feb 28, 2007 at 02:20:01AM -0500, Tom Lane wrote: > "Hiroshi Saito" <[EMAIL PROTECTED]> writes: > > Is this message necessary for setting errno again? > > AFAIR we only intended that message as a temporary measure until we'd > figured out why things seemed to be failing on Windows. If the