Re: Covering GiST indexes

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Covering GiST indexes
Date: 2018-07-29 10:50:10
Message-ID: 850AE105-F89A-42E4-AD40-FBC6EA5A5A00@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, Thomas!

> 29 июля 2018 г., в 14:28, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> написал(а):
>
> On Fri, Jul 6, 2018 at 5:27 AM, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>> Here is v3 version of the patch. I've fixed some comments and added some words to docs.
>
> Hi again Andrey,
>
> Cfbot reported the following difference (twice) in the
> index_including_gist test:
>
> - ERROR: included columns must not intersect with key columns
> + ERROR: relation "tbl_gist_idx" already exists
>
> Well, both of those errors are valid complaints in this case... maybe
> the order of checks changed in master since you wrote the patch?
> Probably better to use a different name for the index anyway.

Thanks! The problem appeared with commit 701fd0b [0] which dropped validation rules checked in failed test. Here's the patch with fixed tests.

Best regards, Andrey Borodin.

[0] https://github.com/postgres/postgres/commit/701fd0bbc98fe8211d36e96f90753985104cd295 <https://github.com/postgres/postgres/commit/701fd0bbc98fe8211d36e96f90753985104cd295>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-07-29 10:57:57 Re: [PATCH] Improve geometric types
Previous Message Thomas Munro 2018-07-29 10:42:32 Re: Removing unneeded self joins