peerdb icon indicating copy to clipboard operation
peerdb copied to clipboard

PG to PG: TSTZRange and JSONB

Open Amogh-Bharadwaj opened this issue 9 months ago • 1 comments

PG to PG CDC:

  • Adds support for JSONB (now maps to JSONB on target)
  • Constructs the string for tstzrange (still text on target) in a way that you can cast to tstzrange like select mytstzrange::tstzrange from table. This would fail before as the string we were inserting was of some json type string. Null lower and upper bounds tested

Functionally tested

Amogh-Bharadwaj avatar May 07 '24 19:05 Amogh-Bharadwaj

What's the motivation for this? PG<>PG should use PG type system to have this accuracy & more. This direction with qvalue is pulled both towards being a common denominator format & a union of everything intersected with postgres. In this case it goes further, supporting distinctions which are only meaningful to postgres. At that point you might as well just be passing pgtype values around

Ideally range types would be generalized

serprex avatar May 07 '24 21:05 serprex

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar May 21 '24 16:05 CLAassistant

#1733 has merged, making this obsolete

serprex avatar May 28 '24 18:05 serprex