Any functional code to be tested to confirm? Regards,
David On Fri, 21 Jan 2022 at 15:55, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > On Fri, 2022-01-21 at 14:33 +0000, Duarte Carreira wrote: > > If we just create the 2 foreign tables, one complete and one without id, > > you can simply insert into the table without id and it will work fine. > > To select and show data, you use the "complete" table that has the id > column. > > > > No need for trigger and view. If I understood correctly. > > > > I have this 2 table setup working. > > > > It's a workaround that quickly escalates out of hand though... with > little added value. > > Sure, that will work. > > I just wanted to show how you can do without dealing with two different > foreign tables explicitly. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > > > >
