Hi Dave,
I am working on a feature to support INCLUDE clause of index in PG-11. As
per the documentation https://www.postgresql.org/docs/11/static/
sql-createindex.html, columns listed in INCLUDE clause cannot also be
present as index key columns. But I find different behaviour for below
queries w
Hi Dave,
I am working on a feature to support INCLUDE clause of index in PG-11. As
per the documentation https://www.postgresql.org/docs/11/static/
sql-createindex.html, columns listed in INCLUDE clause cannot also be
present as index key columns. But I find different behaviour for below
queries w
Hi Team,
Please ignore the name after "Hi" in the previous mail. :/
The potential bug is a mentioned in the mail.
On Tue, Jul 10, 2018 at 6:37 PM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:
> Hi Dave,
>
> I am working on a feature to support INCLUDE clause of index in PG-11.
Aditya Toshniwal writes:
> I am working on a feature to support INCLUDE clause of index in PG-11. As
> per the documentation https://www.postgresql.org/docs/11/static/
> sql-createindex.html, columns listed in INCLUDE clause cannot also be
> present as index key columns. But I find different behav
On Tue, Jul 10, 2018 at 6:37 PM, Aditya Toshniwal
wrote:
> Hi Dave,
>
> I am working on a feature to support INCLUDE clause of index in PG-11. As
> per the documentation
> https://www.postgresql.org/docs/11/static/sql-createindex.html, columns
> listed in INCLUDE clause cannot also be present as i
Hi!
> 10 июля 2018 г., в 17:54, Tom Lane написал(а):
>
> Aditya Toshniwal writes:
>> I am working on a feature to support INCLUDE clause of index in PG-11. As
>> per the documentation https://www.postgresql.org/docs/11/static/
>> sql-createindex.html, columns listed in INCLUDE clause cannot als
On Tue, 10 Jul 2018 20:37:49 +0400
Andrey Borodin wrote:
> Hi!
>
> > 10 июля 2018 г., в 17:54, Tom Lane написал(а):
> >
> > Aditya Toshniwal writes:
> >> I am working on a feature to support INCLUDE clause of index in PG-11. As
> >> per the documentation https://www.postgresql.org/docs/11/sta
On Thu, 12 Jul 2018 15:58:08 +0900
Yugo Nagata wrote:
> Yes, more simplly, the following query also works;
>
> CREATE INDEX ON test((i)) INCLUDE (i);
>
> However, a problem is that when we use pg_dump for the database, this
> generate the following query
>
> CREATE INDEX test_i_i1_idx ON p
Yugo Nagata writes:
> To fix this, we agree with Tom about getting rid of "must not intersect"
> restriction.
> A patch is attached for this
Pushed, after fixing documentation and regression tests to match.
regards, tom lane
Hi Team,
Please ignore the name after "Hi" in the previous mail. :/
The potential bug is a mentioned in the mail.
On Tue, Jul 10, 2018 at 6:37 PM, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:
> Hi Dave,
>
> I am working on a feature to support INCLUDE clause of index in PG-11.
Aditya Toshniwal writes:
> I am working on a feature to support INCLUDE clause of index in PG-11. As
> per the documentation https://www.postgresql.org/docs/11/static/
> sql-createindex.html, columns listed in INCLUDE clause cannot also be
> present as index key columns. But I find different behav
On Tue, Jul 10, 2018 at 6:37 PM, Aditya Toshniwal
wrote:
> Hi Dave,
>
> I am working on a feature to support INCLUDE clause of index in PG-11. As
> per the documentation
> https://www.postgresql.org/docs/11/static/sql-createindex.html, columns
> listed in INCLUDE clause cannot also be present as i
Hi!
> 10 июля 2018 г., в 17:54, Tom Lane написал(а):
>
> Aditya Toshniwal writes:
>> I am working on a feature to support INCLUDE clause of index in PG-11. As
>> per the documentation https://www.postgresql.org/docs/11/static/
>> sql-createindex.html, columns listed in INCLUDE clause cannot als
On Tue, 10 Jul 2018 20:37:49 +0400
Andrey Borodin wrote:
> Hi!
>
> > 10 июля 2018 г., в 17:54, Tom Lane написал(а):
> >
> > Aditya Toshniwal writes:
> >> I am working on a feature to support INCLUDE clause of index in PG-11. As
> >> per the documentation https://www.postgresql.org/docs/11/sta
On Thu, 12 Jul 2018 15:58:08 +0900
Yugo Nagata wrote:
> Yes, more simplly, the following query also works;
>
> CREATE INDEX ON test((i)) INCLUDE (i);
>
> However, a problem is that when we use pg_dump for the database, this
> generate the following query
>
> CREATE INDEX test_i_i1_idx ON p
Yugo Nagata writes:
> To fix this, we agree with Tom about getting rid of "must not intersect"
> restriction.
> A patch is attached for this
Pushed, after fixing documentation and regression tests to match.
regards, tom lane
16 matches
Mail list logo