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; ret

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 > >

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 notati

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?

[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: exports.tx

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

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 Linna

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-thro

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 custo

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, t

[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 dif

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

2008-04-30 Thread chris . johnson
Simon Riggs <[EMAIL PROTECTED]> wrote on 04/30/2008 07:49:44 AM: > 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 coordin

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 Herrerahttp:

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 blocke

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 option implemented by this patch

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 option implemented by this patch enables that coordination. I considered adding the ability to override t

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