Date: Tue, 10 Sep 2024 09:10:00 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: sanskar@flintk12.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18607: UNION ALL discards all foreign key relations +
 indexes
Message-ID: <Zt_wyM5koKKmOmdn@depesz.com>
Reply-To: depesz@depesz.com
References: <18607-651aa996c1e71d48@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <18607-651aa996c1e71d48@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/Zt_wyM5koKKmOmdn%40depesz.com>
Precedence: bulk

On Mon, Sep 09, 2024 at 03:16:33PM +0000, PG Bug reporting form wrote:
> Consider the query below -> 
> 
> "
> CREATE OR REPLACE VIEW v3.temp_view AS
> SELECT * FROM users WHERE id = 'e-1'
> UNION ALL
> SELECT * FROM users WHERE id = 'e-2';
> "
> 
> groups.id is a primary key and has a unique index defined on the same.

What is groups? Your view is named "temp_view", and it's using "users",
not "groups".

> Either way when the view is created, the indexes and the related relations
> of the foreign key references are being dropped. 
> (Same with "UNION").

What do you mean dropped? You had index on column id in table users, and
after view creation you don't have anymore?

Can you please show full example, that I can run on empty database, that
exhibits the problem?

Best regards,

depesz