Re: [I] [Bug] PostgreSQL-CDC] pg实时同步不支持GEOMETRY 类型 [seatunnel]

[via GitHub]

Tenvie commented on issue #10155:
URL: https://github.com/apache/seatunnel/issues/10155#issuecomment-3614965491

   > <img alt="Image" width="944" height="311" 
src="https://private-user-images.githubusercontent.com/200727089/522373980-7af894a9-c39a-4013-b642-ba916d7f8b5f.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjQ4OTkwMjIsIm5iZiI6MTc2NDg5ODcyMiwicGF0aCI6Ii8yMDA3MjcwODkvNTIyMzczOTgwLTdhZjg5NGE5LWMzOWEtNDAxMy1iNjQyLWJhOTE2ZDdmOGI1Zi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMjA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTIwNVQwMTM4NDJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wMmNmMDZiYTdmODI4ZjFiM2Y4MWZhNDkzZGRiNDE5OTBjZDEyNzUzZjkxMGRjMjVkOWNiYzkwMmViYWE5OWYzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.XXvoeVR8PDCBH9lAk2J29GFRYQPuuDpOoI-rdxwO3nY";>
   > Hello, based on the current check, it seems that the issue is that the 
sink side does not support the GEOMETRY type. It should be resolved simply by 
changing the data type on the sink side to string. As can be seen from the 
figure above, the data type mapping is GEOMETRY --> string. It is recommended 
to set the corresponding type on the sink side to string and have a try.
   
   After changing to string type, the synchronized data is incorrect, and 
non-CDC PostgreSQL synchronization of the GEOMETRY type works normally.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org