Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: When using pg_standby to remain in recovery mode on a warm standby system, if there is a need to perform other actions in coordination with recovery actions, the -x auxiliary command option implemented by this patch enables that coordination. I considered adding the

Re: [PATCHES] pg_postmaster_reload_time() patch

2008-04-30 Thread Heikki Linnakangas
Gurjeet Singh wrote: On Wed, Apr 30, 2008 at 9:53 AM, George Gensure [EMAIL PROTECTED] wrote: I've done a quick write up for reload time reporting from the administration TODO. I was a little paranoid with the locking, but didn't want problems to occur with signals on the postmaster and the

Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread Simon Riggs
On Wed, 2008-04-30 at 11:29 +0100, Heikki Linnakangas wrote: [EMAIL PROTECTED] wrote: When using pg_standby to remain in recovery mode on a warm standby system, if there is a need to perform other actions in coordination with recovery actions, the -x auxiliary command option implemented by

Re: [PATCHES] pg_postmaster_reload_time() patch

2008-04-30 Thread Alvaro Herrera
George Gensure escribió: I've done a quick write up for reload time reporting from the administration TODO. I was a little paranoid with the locking, but didn't want problems to occur with signals on the postmaster and the read side. I'd say too much -- postmaster runs with signals blocked

Re: [PATCHES] Documentation: ALTER ROLE - no password

2008-04-30 Thread Alvaro Herrera
Andreas 'ads' Scherbaum wrote: Hello, i've seen the question how to remove a password now several times in the last weeks. Attached is a small patch which add a new example for the ALTER ROLE documentation. Applied, thanks. -- Alvaro Herrera

[PATCHES] fix for pl/pythons named OUT parameter handling

2008-04-30 Thread Hannu Krosing
Before this patch, pl/python will not do the right thing if OUT parameters are present Hannu Index: plpython/plpython.c === RCS file: /projects/cvsroot/pgsql/src/pl/plpython/plpython.c,v retrieving revision 1.106

Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread David Fetter
On Wed, Apr 30, 2008 at 12:49:44PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 11:29 +0100, Heikki Linnakangas wrote: This could be implemented by a pass-through restore_command, that calls pg_standby, and does the custom action when pg_standby returns successfully. Yes, that's the

Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread Simon Riggs
On Wed, 2008-04-30 at 07:31 -0700, David Fetter wrote: On Wed, Apr 30, 2008 at 12:49:44PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 11:29 +0100, Heikki Linnakangas wrote: This could be implemented by a pass-through restore_command, that calls pg_standby, and does the custom action

Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread David Fetter
On Wed, Apr 30, 2008 at 03:43:54PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 07:31 -0700, David Fetter wrote: On Wed, Apr 30, 2008 at 12:49:44PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 11:29 +0100, Heikki Linnakangas wrote: This could be implemented by a pass-through

Re: [PATCHES] Patch to add a feature to pg_standby

2008-04-30 Thread Simon Riggs
On Wed, 2008-04-30 at 08:29 -0700, David Fetter wrote: On Wed, Apr 30, 2008 at 03:43:54PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 07:31 -0700, David Fetter wrote: On Wed, Apr 30, 2008 at 12:49:44PM +0100, Simon Riggs wrote: On Wed, 2008-04-30 at 11:29 +0100, Heikki Linnakangas

Re: [PATCHES] pg_postmaster_reload_time() patch

2008-04-30 Thread George Gensure
On Wed, Apr 30, 2008 at 8:16 AM, Alvaro Herrera [EMAIL PROTECTED] wrote: George Gensure escribió: I've done a quick write up for reload time reporting from the administration TODO. I was a little paranoid with the locking, but didn't want problems to occur with signals on the

[PATCHES] libpq object hooks

2008-04-30 Thread Merlin Moncure
Attached is an updated version of 'libpq object hooks'. The primary purpose for libpq object hooks is to support our libpqtypes system (not attached), but could possibly some nice sideband features to libpq. We are hoping to sneak this into the May commit fest. regards, merlin Index:

Re: [PATCHES] [HACKERS] Proposed patch - psql wraps at window width

2008-04-30 Thread Alvaro Herrera
Gregory Stark wrote: Alvaro Herrera [EMAIL PROTECTED] writes: I think that could be fixed easily by having the syntax be something like \pset format aligned:80 \pset format aligned:autowrap I suppose. It seems kind of inconvenient though, what advantage does it have? Over what? I

Re: [PATCHES] [HACKERS] Proposed patch - psql wraps at window width

2008-04-30 Thread Gregory Stark
Alvaro Herrera [EMAIL PROTECTED] writes: The fact that it's wrapped is not a new format in itself, just a property of the aligned format. Well I agree I just don't see any benefit to presenting it that way. I mean, sure wrapped means aligned and wrapped, but it's just shorthand notation

Re: [PATCHES] temporal version of generate_series()

2008-04-30 Thread H . Harada
Here's the sync and updated patch. It contains strict in catalog as well. Hitoshi Harada 2008/4/24 H. Harada [EMAIL PROTECTED]: 2008/4/23 Alvaro Herrera [EMAIL PROTECTED]: H.Harada escribió: # This is my first time to send a patch. If I did something wrong, I appreciate your

Re: [PATCHES] temporal version of generate_series()

2008-04-30 Thread Pavel Stehule
Hello why you don't use polymorphic types? like: create or replace function generate_time_series(anyelement, anyelement, interval, OUT result anyelement) returns setof anyelement as $$ begin result := $1; while (result = $2) loop return next; result := result + $3; end loop;