On Tue, Sep 10, 2024 at 12:41:14PM +0530, Sanskar Agrawal wrote:
> Yes consider a small table as users with users.id as primary key,
>
> took two rows from the same and ran a union all it tends to drop the
> indexes + foreign relations
Please show full example that I can run on empty DB.
Set of create table statement(s), adding indexes, foreign keys, and then
create view, that results in dropped indexes/foreign keys.
Best regards,
depesz