Re: Top five challenges
From:
Bruce Momjian <bruce(at)momjian(dot)us>
To:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc:
sad <sad(at)bestmx(dot)ru>, pgsql-advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject:
Re: Top five challenges
Date:
2011-03-10 16:01:57
Message-ID:
201103101601.p2AG1vW14016@momjian.us (view raw or flat )
Thread:
2011-02-22 08:44:13 from Susanne Ebrecht <miracee(at)web(dot)de>
2011-02-22 09:29:51 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-22 12:16:21 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-02-22 13:09:39 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-22 19:17:56 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-22 19:44:57 from Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
2011-02-22 19:53:07 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-23 11:01:31 from Susanne Ebrecht <miracee(at)web(dot)de>
2011-02-23 11:05:15 from Dave Page <dpage(at)pgadmin(dot)org>
2011-02-23 18:15:40 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-23 23:33:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-24 22:26:38 from PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
2011-02-24 23:14:37 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-24 23:20:35 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-24 23:28:20 from Dave Page <dpage(at)pgadmin(dot)org>
2011-02-25 07:13:29 from Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
2011-02-25 07:37:10 from Guillaume Lelarge <guillaume(at)lelarge(dot)info>
2011-02-25 08:04:50 from Rob Wultsch <wultsch(at)gmail(dot)com>
2011-02-26 04:11:56 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2011-02-26 05:37:30 from Mike Ellsworth <younicycle(at)gmail(dot)com>
2011-02-26 21:35:12 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-26 21:39:52 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-26 21:41:10 from Selena Deckelmann <selena(at)chesnok(dot)com>
2011-02-26 21:46:41 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-26 21:51:20 from Selena Deckelmann <selena(at)chesnok(dot)com>
2011-02-26 21:54:27 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-26 22:01:01 from Selena Deckelmann <selena(at)chesnok(dot)com>
2011-02-27 20:36:15 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-02-27 21:55:52 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-27 08:45:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-28 19:58:57 from damien clochard <damien(at)dalibo(dot)info>
2011-02-28 20:02:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-03-01 06:39:35 from silly sad <sad(at)bestmx(dot)ru>
2011-03-01 07:23:28 from Thom Brown <thom(at)linux(dot)com>
2011-03-01 11:46:26 from Florian Weimer <fweimer(at)bfk(dot)de>
2011-03-01 13:15:46 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-03-02 13:35:59 from sad(at)bestmx(dot)ru
2011-03-02 14:08:06 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-03-02 00:36:36 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-03-02 13:23:53 from sad(at)bestmx(dot)ru
2011-03-02 14:07:28 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-03-03 11:01:21 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 16:01:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-03-10 16:45:44 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 16:45:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-03-10 16:53:55 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 17:07:09 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2011-03-10 17:15:34 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 17:48:46 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2011-03-10 17:57:48 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 17:52:47 from Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
2011-03-11 07:04:08 from silly sad <sad(at)bestmx(dot)ru>
2011-03-10 18:07:46 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2011-03-02 03:55:53 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2011-03-02 05:02:53 from Robert Treat <rob(at)xzilla(dot)net>
2011-03-10 16:00:03 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-03-02 16:25:23 from Grant Slater <postgresql(at)firefishy(dot)com>
2011-03-02 16:36:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-03-03 17:58:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-03-04 03:23:07 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2011-02-25 02:57:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-25 09:23:25 from Susanne Ebrecht <miracee(at)web(dot)de>
2011-02-25 09:45:18 from Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
2011-02-25 09:47:50 from Dave Page <dpage(at)pgadmin(dot)org>
2011-02-25 10:13:23 from Thom Brown <thom(at)linux(dot)com>
2011-02-25 13:59:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-25 06:58:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-25 09:09:59 from damien clochard <damien(at)dalibo(dot)info>
2011-02-23 23:31:59 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-24 22:27:46 from PostgreSQL - Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Lists:
pgsql-advocacy pgsql-www
Alvaro Herrera wrote:
> Excerpts from sad's message of mi mar 02 10:23:53 -0300 2011:
> > On Mar 2 2011, Josh Berkus wrote:
>
> > >> 3. To make TIMESTAMPTZ useful by introducing proper type cast
> > >> TIMESTAMPTZ to TIMESTAMP
> > >
> > >Why are you using Timestamp-no-tz at all? I was thinking we should
> > >change the default ...
> >
> > Why did u introduced it?
>
> The standard requires the current behavior. It's not going to change.
> It changed in 7.1 or so.
And we document why the default is so odd:
http://www.postgresql.org/docs/9.0/static/datatype-datetime.html#DATATYPE-TIMEZONES
Note: The SQL standard requires that writing just timestamp be
equivalent to timestamp without time zone, and PostgreSQL honors that
behavior. (Releases prior to 7.3 treated it as timestamp with time
zone.)
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
In response to
Responses
pgsql-www by date
Next :From: Bruce MomjianDate: 2011-03-10 16:45:02Subject : Re: Top five challengesPrevious :From : Bruce MomjianDate : 2011-03-10 16:00:03Subject : Re: Top five challenges
pgsql-advocacy by date
Next :From: Bruce MomjianDate: 2011-03-10 16:45:02Subject : Re: Top five challengesPrevious :From : Bruce MomjianDate : 2011-03-10 16:00:03Subject : Re: Top five challenges
