Re: default parameters for built-in functions (was Re: Documentation Update: Document pg_start_backup checkpoint behavior) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: default parameters for built-in functions (was Re: Documentation Update: Document pg_start_backup checkpoint behavior)
Date
Msg-id 20090406232856.GN4525@alvh.no-ip.org
Whole thread Raw
In response to default parameters for built-in functions (was Re: Documentation Update: Document pg_start_backup checkpoint behavior)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: default parameters for built-in functions (was Re: Documentation Update: Document pg_start_backup checkpoint behavior)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> The only alternative that comes to mind is
> to have initdb issue an additional SQL command to establish the default
> after the bootstrap phase; that is, something like
> 
> CREATE OR REPLACE FUNCTION
>   pg_start_backup(label text, fast boolean DEFAULT false)
>   RETURNS text LANGUAGE internal STRICT AS 'start_backup';
> 
> in system_views.sql or some such place.

I think it's worth having this, perhaps as a new SQL file to be called
by initdb.  I'm sure we can come up with new system functions for which
it's going to be useful to have default values.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: default parameters for built-in functions (was Re: Documentation Update: Document pg_start_backup checkpoint behavior)
Next
From: Tom Lane
Date:
Subject: Re: unchecked out of memory in postmaster.c