From: | vignesh C <vignesh21(at)gmail(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | zzzzz(dot)graf(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #18203: Logical Replication initial sync failure |
Date: | 2023-11-21 05:28:05 |
Message-ID: | CALDaNm2kSJCVree6R1iKxjbA=Sg4raFi3Fi_+wfF2xn2roxqCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, 20 Nov 2023 at 18:38, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Mon, Nov 20, 2023 at 2:53 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> >
> > >
> > > Logical replication worker returns with the following error:
> > > 2023-11-17 20:40:16.141 UTC [151084] ERROR: could not start initial
> > > contents copy for table "public.no_col": ERROR: syntax error at or near
> > > ")"
> > > LINE 1: COPY public.no_col () TO STDOUT
> >
> > Thanks for reporting this issue, I was able to reproduce the issue.
> > This issue is happening because we are trying to specify the column
> > list while the table sync worker is copying data for the table.
> > I felt we should not specify the column list when the table has no columns.
> > Attached patch has the changes to handle the same.
> >
>
> I think we can add a test for such cases which tests both initial sync
> and regular replication on a table with no column.
I have added a test for the same and tested upto PG15 where the
changes were added.
The patches for the same are attached.
Regards,
Vignesh
Attachment | Content-Type | Size |
---|---|---|
v2-0001-Specify-parenthesis-for-tablesync-worker-copy-com.patch | text/x-patch | 4.4 KB |
v2-0001-Specify-parenthesis-for-tablesync-worker-copy-com_PG15.patch | text/x-patch | 4.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | vignesh C | 2023-11-21 05:30:58 | Re: BUG #18203: Logical Replication initial sync failure |
Previous Message | Tom Lane | 2023-11-21 02:13:01 | Re: About #13489, array dimensions and CREATE TABLE ... LIKE |