Partial Index on Postgres where condition is in separate table

Question

I have table schema as:

table_a:
    id
    active boolean
 
table_b:
    id
    table_a_id ForeignKey

I want to apply a partial unique index on table_b but only if active=True for table_a_id.

Is this feasible in postgres?

I don't think that you want to create an index on another table will be worked. — D-Shih
– D-Shih, Commented Mar 11, 2022 at 10:05

Frank Heikens · Accepted Answer · 2022-03-11 14:22:40Z

5

Not possible. From the manual:

The expression used in the WHERE clause can refer only to columns of the underlying table, but it can use all columns, not just the ones being indexed.

answered Mar 11, 2022 at 14:22

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Partial Index on Postgres where condition is in separate table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related