Question 89981 in PostgreSQL Question posted in
The official documentation can be found here.

Google DataStream character varying not being replicated – Postgresql

I have setup Google DataStream to replicate data from PostgresSQL using CDC. It works fine, but I have noticed that all character varying columns are not being replicated. I can see them in the source schema, but the destination table that been created it doesn’t have that column at all.

Tags:

2

Answers


  1. 0

    Akram – if I am not mistaken you will see the new column only AFTER you add some data to that column. The same applies to new tables created in source DB (in case you select the option to replicate all new tables when setting up replication publication in PostgreSQL)

    Login or Signup to reply.
  2. 0

    At the moment Datastream for Postgresql has "Public preview" status and does not yet support the replication of "character varying []" (and if I’m not mistaken "citex" as well) Postgresql data types.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search