Materialize/doc/user/content/releases/v0.70.md

---

title: "Materialize v0.70" date: 2023-09-27 released: true

patch: 2

v0.70.0

Sources and sinks

• Automatically check if there are tables not currently configured to use REPLICA IDENTITY FULL in a publication used with a PostgreSQL source.

• Support constraining the precision of the fractional seconds in timestamps. This allows users to construct Avro-formatted sinks that use the timestamp-millis logical type instead of the timestamp-micros logical type.

Bug fixes and other improvements

• Limit the amount of data that can be copied using COPY FROM to 1 GiB. Please contact us if you need this limit increased in your Materialize region.

• Restrict transactions to execute on a single cluster, in order to improve use case isolation. The first query in a transaction now determines the time domain of the entire transaction {{% gh 21854 %}}.