| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Duarte Carreira <dncarreira(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Swathi P <swathi(dot)bluepearl(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Query on postgres_fdw extension |
| Date: | 2022-01-21 15:54:59 |
| Message-ID: | 881a552bf99081609275aa9fe151073ad569c059.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2022-01-21 16:26:56 | Re: Query on postgres_fdw extension |
| Previous Message | Tom Lane | 2022-01-21 15:20:46 | Re: BUG #17375: RECOVERY TARGET TIME RESTORE IS FAILING TO START SERVER |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alanoly Andrews | 2022-01-21 16:24:14 | Using a different column name in a foreign table |
| Previous Message | Paul Ramsey | 2022-01-21 15:32:55 | Re: proj_create errors in EDB 13.5 installation macOS |