From:
Stephen Frost <sfrost(at)snowman(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Proposal: Store "timestamptz" of database creation on
"pg_database"
Date:
2013-01-03 02:12:06
Message-ID:
20130103021206.GX16126@tamriel.snowman.net (view raw or flat )
Thread:
2012-12-27 00:48:52 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-27 01:08:13 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-27 01:30:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 04:13:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-27 04:32:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 05:33:01 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-27 12:08:56 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 16:04:42 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-27 23:02:36 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-28 02:14:58 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-28 10:04:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-28 12:05:57 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-28 18:53:05 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-29 14:12:07 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-29 14:34:41 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-29 14:45:00 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-29 14:59:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-29 15:26:18 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-29 15:49:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 01:35:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 02:01:48 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 10:03:17 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 10:18:08 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-03 11:34:23 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 13:17:46 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:40:33 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 13:42:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:46:20 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 14:09:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 16:15:31 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 17:27:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 17:54:45 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2013-01-03 20:26:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-04 18:07:37 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-05 15:48:40 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-05 16:04:43 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-05 17:59:30 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-05 19:31:53 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-07 00:54:48 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-07 13:42:32 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-08 15:08:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-08 22:09:23 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-08 22:12:21 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-08 22:17:41 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 04:42:45 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-08 13:47:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 14:18:38 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-03 10:20:09 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 13:15:51 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 22:58:36 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 01:52:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 02:02:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-03 02:12:06 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 04:04:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 10:28:15 from Bernd Helmle <mailings(at)oopsware(dot)de>
2013-01-03 10:54:03 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 02:06:01 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 08:16:59 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 16:38:49 from Greg Stark <stark(at)mit(dot)edu>
2013-01-03 04:08:26 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:13:11 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:33:47 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:40:09 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:41:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 15:00:05 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 14:12:25 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-03 14:18:02 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 14:22:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 14:30:12 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-03 15:17:07 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 16:17:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> If I believed that it would be a hundred-line patch, and would *stay*
> a hundred-line patch, I'd be fine with it. But it won't. I will
> bet a very fine dinner that the feature wouldn't get out the door
> before there would be demands for pg_dump support.
Fine, how about a function that can be called by pg_dump (and anyone
else who has the rights and feels the need) to set that value? That
avoids all need for any new syntax and still gives us the pg_dump and
friends support that will apparently be asked for.
> And arguments
> about whether ALTER should or should not change the timestamp.
There is no case where ALTER should change the *creation* time, imo.
> And I doubt you counted psql \d support in that hundred lines.
> So this is just a can of worms that I'd rather not open.
The last psql \d support change that I looked at (thanks Jon) had a
diffstat (excluding documentation and whitespace changes) of:
sfrost(at)beorn:/home/sfrost/Downloads> cat qq | diffstat
describe.c | 5 +++++
1 file changed, 5 insertions(+)
Just saying. ;)
Thanks,
Stephen
In response to
Responses
pgsql-hackers by date
Next :From: Noah MischDate: 2013-01-03 03:13:58
Subject : Problematic dependency in plpython Makefile [Windows]
Previous :From : Stephen FrostDate : 2013-01-03 02:06:01
Subject : Re: Proposal: Store "timestamptz" of database creation on
"pg_database"