W-dragan commented on PR #5986:
URL: https://github.com/apache/seatunnel/pull/5986#issuecomment-1928644263
I found that there is currently no CDC that supports PG partition tables.
For example, I created a people table, CREATE TABLE public-person（
Id int4 NOT NULL,
Birth_ Date date NOT NULL,
Country_ Code bpchar (2) NOT NULL,
"Name" text NULL,
CONSTRAINT people_ Pk PRIMAY KEY (id, birthdate)
）
PARTY BY RANGE (birthdate);
Then create 3 more partitions
--Publicpeople_ Y2000 definition
CREATE Table publicpeople_ Y2000 PARTY OF public people FOR VALUES From
('2000-01-01 ') TO ('2001-01-01');
--Publicpeople_ Y2000 foreign keys
--Publicpeople_ Y2001 definition
CREATE Table publicpeople_ Y2001 PARTY OF public people FOR VALUES FOR
('2001-01-01 ') TO ('2002-01-01');
--Publicpeople_ Y2001 foreign keys
--Publicpeople_ Y2002 definition
CREATE Table publicpeople_ Y2002 PARTY OF public people FOR VALUES FOR
('2002-01-01 ') TO ('2003-01-01');
--Publicpeople_ Y2002 foreign keys
When I configure the use of the People table in my source configuration, I
cannot query the table because it is a partition type. Even if I modify the
code to forcibly query the table, I cannot perform CDC operations on it
@Carl-Zhou-CN @EricJoy2048
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
