Thread: Logical decoding plugin
Hi! I'm an intern, and I work on logical decoding plugin on PG.
I'm in troubles when I have a DELETE action on a table who don't have a primary key, in my C plugin :
the new tuple is empty
the old tuple is empty too
and there are not primary key....
Is it possible to get information about the deleted row ?
Thanks for all
On Thu, Jul 28, 2016 at 5:40 PM, remi colli <RCD18@hotmail.fr> wrote: > Hi! I'm an intern, and I work on logical decoding plugin on PG. > > > I'm in troubles when I have a DELETE action on a table who don't have a > primary key, in my C plugin : > > the new tuple is empty > > the old tuple is empty too > and there are not primary key.... > > Is it possible to get information about the deleted row ? What is the value of REPLICA IDENTITY for this table? You can identify an old tuple by using either USING INDEX or FULL in your plugin. -- Michael