From: | Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: WIP: Covering + unique indexes. |
Date: | 2016-01-19 17:15:46 |
Message-ID: | 569E6F42.9040601@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
12.01.2016 20:47, Jeff Janes:
> It looks like the "covering" patch, with or without the "omit_opclass"
> patch, does not support expressions as included columns:
>
> create table foobar (x text, y xml);
> create index on foobar (x) including (md5(x));
> ERROR: unrecognized node type: 904
> create index on foobar (x) including ((y::text));
> ERROR: unrecognized node type: 911
>
> I think we would probably want it to work with those (or at least to
> throw a better error message).
Thank you for the notice. I couldn't fix it quickly and added a stub in
the latest patch.
But I'll try to fix it and add expressions support a bit later.
--
Anastasia Lubennikova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2016-01-19 17:18:52 | Re: [Proposal] Table partition + join pushdown |
Previous Message | Anastasia Lubennikova | 2016-01-19 17:08:07 | Re: WIP: Covering + unique indexes. |