Postgres Pro
Downloads
Home   >   mailing lists

Re: Support logical replication of DDLs - Mailing list pgsql-hackers

From Ajin Cherian
Subject Re: Support logical replication of DDLs
Date
Msg-id CAFPTHDb=r=e+ztQr_krgusqjRWm-5PRCEJju0NRLKsjoVTM8fQ@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of DDLs  (vignesh C <vignesh21@gmail.com>)
Responses RE: Support logical replication of DDLs  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-hackers
Tree view 
On Tue, Feb 7, 2023 at 11:05 PM vignesh C <vignesh21@gmail.com> wrote:
>
> On Mon, 6 Feb 2023 at 17:02, vignesh C <vignesh21@gmail.com> wrote:
> >
> I found few issues while testing:
> Issue 7: no owned sequence found
> Steps to reproduce:
> CREATE TABLE itest13 (a int);
> ALTER TABLE itest13 ADD COLUMN b int GENERATED BY DEFAULT AS IDENTITY;
>

I've fixed this issue. The reason for the failure was because, for
implicitly generated sequences,
the sequence relation is stored in coldef->identitysequence and has to
be fetched from there.
The fix is in patch-0002

regards,
Ajin Cherian
Fujitsu Australia
Attachment

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pgindent vs. git whitespace check
Next
From: Melih Mutlu
Date:
Subject: Re: Allow logical replication to copy tables in binary format