Re: Postgres-native method to identify if a tuple is frozen

2020-07-27 Thread Lawrence Jones
;tuple, &buf)) #endif { result = 3; } else { result = HeapTupleHeaderXminFrozen(tuple.t_data); } // Close any opened resources here heap_close(rel, AccessShareLock); ReleaseBuffer(buf); PG_RETURN_INT32(result); } On Tue, 21 Jul 2020 at 13:22, Amit Kapila wrote: > On Mon, Jul 20, 2020 at 9:07 PM L

Postgres-native method to identify if a tuple is frozen

2020-07-20 Thread Lawrence Jones
Hey all, *tl;dr: we're looking for an easy way to ask if a tuple is frozen from within a SQL query* We're trying to build a validation process around our CCD, in an attempt to validate that all data inside of Postgres has made it into our secondary store. Our plan is to build a small incremental