Re: [PATCHES] Are you actively hacking on 2PC?

2005-06-07 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom, please let me know if you want to hack on it, if that's the case > I'll stop my cleanup and start to work on supporting the things that > need further coding, which are AFAICS MultiXactId, large objects and > notifies. Well, I am just finishing up

Re: [PATCHES] using strxfrm for having multi locale/please vote for

2005-06-07 Thread Peter Eisentraut
Bruce Momjian wrote: > > Sounds like pie in the sky to me. Exactly how do you think that > > ICU will magically mask the fundamental semantic inconsistency? > > I am hoping ICU will allow us to see the next greatest value for that > character. As Tom says, it's a semantic inconsistency, not a lac

Re: [PATCHES] SQLSTATE and SQLERRM

2005-06-07 Thread Pavel Stehule
On Tue, 7 Jun 2005, Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian writes: > > > Seems OK to allow them to be visible outside an exception. > > > > Pavel just told me off-list that he'd reconsidered and now likes > > the other way better. So please hold off applying this patch; > > th

Re: [PATCHES] SQLSTATE and SQLERRM

2005-06-07 Thread Tom Lane
Bruce Momjian writes: > Seems OK to allow them to be visible outside an exception. Pavel just told me off-list that he'd reconsidered and now likes the other way better. So please hold off applying this patch; there will be another one by and by. regards, tom lane -

Re: [PATCHES] SQLSTATE and SQLERRM

2005-06-07 Thread Bruce Momjian
Patch retracted by author; new one coming. --- Pavel Stehule wrote: > Hello > > This patch respect last Tom's Lane notes. Is based on first variante, > > http://archives.postgresql.org/pgsql-committers/2005-05/msg00303.p

Re: [PATCHES] SQLSTATE and SQLERRM

2005-06-07 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Seems OK to allow them to be visible outside an exception. > > Pavel just told me off-list that he'd reconsidered and now likes > the other way better. So please hold off applying this patch; > there will be another one by and by. Roger. -- Bruce

Re: [PATCHES] SQLSTATE and SQLERRM

2005-06-07 Thread Bruce Momjian
Pavel Stehule wrote: > Hello > > This patch respect last Tom's Lane notes. Is based on first variante, > > http://archives.postgresql.org/pgsql-committers/2005-05/msg00303.php > > SQLSTATE and SQLERRM are local variables blocks with EXCEPTION clause. > I wonted respect a litlle bit Oracle beha

Re: [PATCHES] using strxfrm for having multi locale/please vote for

2005-06-07 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Alvaro Herrera wrote: > >>> There are some things I think ICU can fix for us like indexing non-C > >>> localed columns. > >> > >> Huh, we already do that, don't we? > > > Sorry, I meant LIKE index usage for non-C columns. We can do that now > > with a

[PATCHES] PQgetGetCopyData() doc. and PQsendQueryGuts() SegFault handling fix.

2005-06-07 Thread Volkan YAZICI
Fixed PQconsumeInput() usage for PQgetCopyData() in libpq.sgml. (Related mail thread: http://archives.postgresql.org/pgsql-novice/2005-06/msg00038.php) Fixed SegFault in PQsendQueryGuts() when user submitted a binary parameter without size. And 2 typo fixes. Index: doc/src/sgml/libpq.sgml ===

Re: [PATCHES] using strxfrm for having multi locale/please vote for

2005-06-07 Thread Tom Lane
Bruce Momjian writes: > Alvaro Herrera wrote: >>> There are some things I think ICU can fix for us like indexing non-C >>> localed columns. >> >> Huh, we already do that, don't we? > Sorry, I meant LIKE index usage for non-C columns. We can do that now > with a special LIKE indexing method, but

Re: [HACKERS] [PATCHES] regexp_replace

2005-06-07 Thread David Fetter
On Tue, Jun 07, 2005 at 10:27:28PM +0900, Atsushi Ogawa wrote: > > David Fetter wrote: > > On Tue, Jun 07, 2005 at 09:35:56AM +0900, a_ogawa wrote: > > > David Fetter wrote: > > > > We don't yet have this functionality, as the patch allows for > > > > using second and later regex matches "()" in t

Re: [PATCHES] using strxfrm for having multi locale/please vote for

2005-06-07 Thread Bruce Momjian
Alvaro Herrera wrote: > On Mon, Jun 06, 2005 at 10:11:15PM -0400, Bruce Momjian wrote: > > Greg Stark wrote: > > > > Yes it's true that on some OSes it wouldn't be tolerably efficient but on > > > glibc it's more than tolerable. If better solutions (strxfrm_l) become > > > available at some point

Re: [PATCHES] uptime function to postmaster

2005-06-07 Thread Bruce Momjian
I think we agreed on pg_postmaster_start_time() so it is clear it is the postmaster, and not the session. 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

Re: [HACKERS] [PATCHES] regexp_replace

2005-06-07 Thread Atsushi Ogawa
David Fetter wrote: > On Tue, Jun 07, 2005 at 09:35:56AM +0900, a_ogawa wrote: > > David Fetter wrote: > > > We don't yet have this functionality, as the patch allows for > > > using second and later regex matches "()" in the replacement > > > pattern. > > > > > > The function is misnamed. It sho

Re: [PATCHES] Server instrumentation: pg_terminate_backend, pg_reload_conf

2005-06-07 Thread Andreas Pflug
Bruce Momjian wrote: Andreas Pflug wrote: Bruce Momjian wrote: Andreas Pflug wrote: This patch reenables pg_terminate_backend, allowing (superuser only, of course) to terminate a backend. As taken from the discussion some weeks earlier, SIGTERM seems to be used quite widely, without a rep

Re: [PATCHES] lastval()

2005-06-07 Thread Neil Conway
Neil Conway wrote: Attached is a revised patch. Applied to HEAD. Thanks for the patch, Dennis. -Neil ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings