Summary
User is experiencing an error related to the
txid_snapshot_xmin()function while setting up a Postgres source connector with CockroachDB, despite switching to the User Defined Cursor option. The user seeks clarification on whether the User Defined Cursor option still utilizes the xmin function.
Question
hi, i am trying to set up a connector using a postgres source and a bigquery destination. the underlying source DB is cockroachDB, which should be compatible with postgres. both source and query tests are passing.
i’d initially set up the postgres source using the xmin option, but i was getting an error that txid_snapshot_xmin(): function undefined. i switched to the Scan Changes with User Defined Cursor option instead and created a new connection that specified the right cursor columns to use (mostly updated_at).
when i test the connection, i get the same txid_snapshot_xmin() error above, which doesn’t seem right since i’m using the cursor option now.
is this expected? does the User Defined Cursor option still use the xmin function above?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.