Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

2019-07-10 Thread Tom Lane
Bruce Momjian writes: > The thing I don't like about 00:00:00 is that it is a lot of information > to say "the start of the day", while I assumed midnight was clear on > that. If we can find a way to say "start of the day (midnight)", that > would work. One really simple way to make it shorter

Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

2019-07-10 Thread Bruce Momjian
On Wed, Jul 10, 2019 at 01:32:31PM -0400, Jonathan Katz wrote: > On 7/10/19 6:13 AM, David Harper wrote: > >> I actually agree with your opinion that "midnight" is fine. > >> That text has been that way for over fifteen years[1], and > >> nobody's complained before that it was ambiguous. > > > > C

Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

2019-07-10 Thread Jonathan S. Katz
On 7/10/19 6:13 AM, David Harper wrote: >> I actually agree with your opinion that "midnight" is fine. >> That text has been that way for over fifteen years[1], and >> nobody's complained before that it was ambiguous. > > Conversely, how many users over the past fifteen years have read that table,

Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

2019-07-10 Thread David Harper
> I actually agree with your opinion that "midnight" is fine. > That text has been that way for over fifteen years[1], and > nobody's complained before that it was ambiguous. Conversely, how many users over the past fifteen years have read that table, and then felt compelled (as I did) to run a q

Re: Postgres 11: Table Partitioning and Primary Keys

2019-07-10 Thread Michael Paquier
On Tue, Jul 09, 2019 at 06:59:59PM -0400, Tom Lane wrote: > Alvaro Herrera writes: >> >> >>Unique constraints on partitioned tables (as well as primary keys) >>must constrain all the partition key columns. This limitation exists >>because PostgreSQL can only e