Re: BUG #18607: UNION ALL discards all foreign key relations + indexes - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: BUG #18607: UNION ALL discards all foreign key relations + indexes
Date
Msg-id Zt_xfCSMgpVoxggF@depesz.com
Whole thread Raw
In response to BUG #18607: UNION ALL discards all foreign key relations + indexes  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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




pgsql-bugs by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #18607: UNION ALL discards all foreign key relations + indexes
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: BUG #18607: UNION ALL discards all foreign key relations + indexes