Hi Keith, I'm getting this error due to logical replication configured. And this error is occurring on the Subscriber Side. In my point of view, Logical Replication worker process is continuously checking and trying to insert each row right from the start even if that particular row has been already present in the table. And that's the reason of this continuous occurring of the error. One small doubt is if a table A has 10 records(which were inserted on the publisher) and all the 10 records were replicated to the subscriber. Now when I insert the 11'th record will it replicate only the last record or try to replicate(or check if all rows have been replicated) all the rows of the table A right from the first?? Please confirm.. If it does the latter(try to replicate all rows) then the above error will arise as table A has replica identity(Primary key). >>If this doesn't fit the model that is causing your duplicate key errors, you may want to look into using a function to do your writes instead and catch the given error in an exception block and then just ignore it. Could you please provide me an example of accomplishing it!! Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
