Обсуждение: Logical decoding plugin

Поиск
Список
Период
Сортировка

Logical decoding plugin

От
remi colli
Дата:

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

Re: Logical decoding plugin

От
Michael Paquier
Дата:
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