Hi hackers! In the nearby thread[0], enhancements for CREATE TABLE LIKE/REPLICA IDENTITY were proposed.
> To me, it makes sense to copy the replica identity definition if INCLUDING INDEXES or INCLUDING CONSTRAINTS is given. I agree that this can be beneficial. But I decided to start with some simpler task, which is also sane (to my belief) and can be used to improve user experience with this feature. This is to allow you to specify REPLICA IDENTITY with CREATE TABLE statement. Currently, it requires 2 (two) DDL statements to define RI for relation (that is CREATE TABLE + ALTER TABLE). My patch indent to enhance this. This was actually proposed 12 years ago in the original thread, see [1]. But at that time this was not considered vital for logical replication to work, so was abandoned. My v1 patch misses documentation and tests, yes, but this is just the initial version to receive feedback, if this has a chance of being committed or not, and general thoughts on the subject. WDYT? [0] https://www.postgresql.org/message-id/202508061804.wwf4zc7npayp%40alvherre.pgsql [1] https://www.postgresql.org/message-id/20131021181629.GI2968%40awork2.anarazel.de -- Best regards, Kirill Reshke
0001-Allow-to-explicitly-set-REPLICA-IDENTITY-with-relati.patch
Description: Binary data
