Re: [HACKERS] Logical Decoding - Execute join query

2016-04-01 Thread Craig Ringer
On 1 April 2016 at 17:45, Andres Freund wrote: > Hi, > > On 2016-04-01 15:09:59 +0530, hari.prasath wrote: > > I tried to execute a join query using SPI_execute() in logical > > decoding part and got inconsistent values (i am referring it as > > inconsistent

Re: [HACKERS] Logical Decoding - Execute join query

2016-04-01 Thread Andres Freund
Hi, On 2016-04-01 15:09:59 +0530, hari.prasath wrote: > I tried to execute a join query using SPI_execute() in logical > decoding part and got inconsistent values (i am referring it as > inconsistent since it is returning the old values which is > present at the postgresql

[HACKERS] Logical Decoding - Execute join query

2016-04-01 Thread hari.prasath
Hi all, I tried to execute a join query using SPI_execute() in logical decoding part and got inconsistent values (i am referring it as inconsistent since it is returning the old values which is present at the postgresql server start). My data directory has to tables table1(a