Re: CREATE STATISTICS and partitoins/inheritance

2022-08-31 Thread Justin Pryzby
On Wed, Aug 31, 2022 at 11:15:41PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 03:30:11PM -0400, Bruce Momjian wrote: > > In looking at CREATE STATISTICS, I was confused how inheritance and > > partisions were handled, so I confirmed with Tomas that the ANALYZE > > manual page accurately

Duplicate text in ANALYZE related to inheritance/parents

2022-08-31 Thread Bruce Momjian
I noticed that our ANALYZE documentation has confusing duplicate text related to the analyzing of inheritance trees. This patch fixes it. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is a

Re: CREATE STATISTICS and partitoins/inheritance

2022-08-31 Thread Bruce Momjian
On Wed, Aug 17, 2022 at 03:30:11PM -0400, Bruce Momjian wrote: > In looking at CREATE STATISTICS, I was confused how inheritance and > partisions were handled, so I confirmed with Tomas that the ANALYZE > manual page accurately describes how extended statistics are handled > since PG 15, so I plan

Re: CREATE INDEX...USING

2022-08-31 Thread Bruce Momjian
On Thu, Aug 18, 2022 at 12:32:28PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 11:21:58PM -0400, Bruce Momjian wrote: > > However, CREATE INDEX just lists the parameters, not the keywords, so it > > was already there as 'method', as you mentioned above. I will just > > remove the USING s

Re: nicer examples for aggregate calls

2022-08-31 Thread Bruce Momjian
On Wed, Aug 17, 2022 at 12:20:10PM -0400, Bruce Momjian wrote: > On Sat, Oct 23, 2021 at 01:51:48PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/14/tutorial-agg.html > > Description: > > >

Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely

2022-08-31 Thread Bruce Momjian
On Tue, Aug 16, 2022 at 03:38:13PM -0400, Bruce Momjian wrote: > On Tue, Aug 16, 2022 at 03:34:22PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > I have written the attached patch to mention this issue about sql_body > > > functions. > > > > Spell-check, please. Seems OK otherwise. > >

Re: set time zone

2022-08-31 Thread Bruce Momjian
On Tue, Aug 16, 2022 at 08:41:05PM -0400, Bruce Momjian wrote: > On Tue, Dec 7, 2021 at 02:28:09PM +, PG Doc comments form wrote: > > TIME ZONE > > SET TIME ZONE timezone_name is an alias for SET timezone TO timezone_name. > > I ended up changing the syntax from 'timezone' to 'value' and adde