| From: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Duarte Carreira <dncarreira(at)gmail(dot)com>, 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 <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query on postgres_fdw extension |
| Date: | 2022-01-21 16:26:56 |
| Message-ID: | CA+i5JwYUQ82=RUPfWD4qefKW+wzm0eRqsd8JsxEim5FmtR2m0Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
Any functional code to be tested to confirm?
Regards,
David
On Fri, 21 Jan 2022 at 15:55, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Japin Li | 2022-01-21 17:27:55 | Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error |
| Previous Message | Laurenz Albe | 2022-01-21 15:54:59 | Re: Query on postgres_fdw extension |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-01-21 16:33:06 | Re: Using a different column name in a foreign table |
| Previous Message | Shaozhong SHI | 2022-01-21 16:26:01 | Re: Can commands be typed in to view geometry in PgAdmin? |