Skip to content

Instantly share code, notes, and snippets.

@wkalt
Created October 29, 2019 04:15
Show Gist options
  • Save wkalt/36720f39c97567fa6cb18cf5c05ac60f to your computer and use it in GitHub Desktop.
Save wkalt/36720f39c97567fa6cb18cf5c05ac60f to your computer and use it in GitHub Desktop.
create table demo (
id int,
useless int,
b boolean
) partition by range (id);
alter table demo drop column useless;
-- only seems to cause failure when it's a partial index on b.
create index on demo(b) where b = 't';
create table demo_1_20191031 partition of demo for values from (1) to (2);
-- psql:test.sql:13: ERROR: unexpected varattno 3 in expression to be mapped
-- Time: 2.619 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment