obsolete indexing method "rtree"

2020-08-05 Thread Jürgen Purtz
We removed the indexing method "rtree" in version 8.3 and replaced it with "gist". Until today there are some "rtree" heritages: * "CREATE INDEX ... USING rtree ..." is valid syntax and leads to the message "NOTICE:  substituting access method gist for obsolete method rtree" * The docume

Re: obsolete indexing method "rtree"

2020-08-05 Thread Tom Lane
=?UTF-8?Q?J=c3=bcrgen_Purtz?= writes: > We removed the indexing method "rtree" in version 8.3 and replaced it > with "gist". Until today there are some "rtree" heritages: > * "CREATE INDEX ... USING rtree ..." is valid syntax and leads to the > message "NOTICE:  substituting access method

Re: obsolete indexing method "rtree"

2020-08-06 Thread Jürgen Purtz
Why? Because it can hinder the learning process. And it's possible that people ignore or forget about the warning message, but are confused somewhat later that commands like \d shows GiST instead of RTREE. It's not hurting anything to continue the substitution in CREATE INDEX. Yes, it's

Re: obsolete indexing method "rtree"

2020-08-06 Thread David G. Johnston
On Thu, Aug 6, 2020 at 12:18 AM Jürgen Purtz wrote: > > > Why? > > Because it can hinder the learning process. FWIW I'd at least fixup comment.sgml to reference a current type. And while in there might as well add missing examples for the following since we seem to have a goal of providing one

Re: obsolete indexing method "rtree"

2020-08-07 Thread Jürgen Purtz
On 06.08.20 10:12, David G. Johnston wrote: On Thu, Aug 6, 2020 at 12:18 AM Jürgen Purtz > wrote: > Why? Because it can hinder the learning process. FWIW I'd at least fixup comment.sgml to reference a current type.  And while in there might as well add miss

Re: obsolete indexing method "rtree"

2020-08-18 Thread David G. Johnston
On Fri, Aug 7, 2020 at 8:46 AM Jürgen Purtz wrote: > > On 06.08.20 10:12, David G. Johnston wrote: > > On Thu, Aug 6, 2020 at 12:18 AM Jürgen Purtz wrote: > >> >> > Why? >> >> Because it can hinder the learning process. > > > > Such a "make current" patch that covers this complaint seems reasona

Re: obsolete indexing method "rtree"

2020-08-21 Thread Bruce Momjian
On Fri, Aug 7, 2020 at 05:46:45PM +0200, Jürgen Purtz wrote: > > On 06.08.20 10:12, David G. Johnston wrote: > > On Thu, Aug 6, 2020 at 12:18 AM Jürgen Purtz wrote: > > > > Why? > > Because it can hinder the learning process. > > > FWIW I'd at least fixup comment.sg