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

---

title: "Materialize v0.51" date: 2023-04-19 released: true

patch: 1

v0.51.0

Sources and sinks

• Add support for replicating tables from specific schemas in the PostgreSQL source, using the new FOR SCHEMAS(...) option:

  CREATE SOURCE mz_source
  FROM POSTGRES CONNECTION pg_connection (PUBLICATION 'mz_source')
  FOR SCHEMAS (public, finance)
  WITH (SIZE = '3xsmall');
  

With this option, only tables that are part of the publication and namespaced with the specified schema(s) will be replicated.

SQL

• Add disk_bytes to the mz_internal.mz_cluster_replica_{metrics, sizes} system catalog tables. This column is currently NULL. In the future, it will allow users to inspect disk utilization for each cluster replica.

• Add the translate string function, which replaces a set of characters in a string with another set of characters (one by one, regardless of the order of those characters):

  SELECT translate('12345', '134', 'ax');
  
  	 translate
  	-----------
  	 a2x5
  

• Add new configuration parameters:

| Configuration parameter | Scope | Description | | ---------------------------- | -------- | --------------------------------------------------------------------------------------- | | enable_session_rbac_checks | Session | Read-only. Boolean flag indicating whether RBAC is enabled for the current session. | | enable_rbac_checks | System | Boolean flag indicating whether to apply RBAC checks before executing statements. Setting this parameter requires superuser privileges. |

This is part of the work to enable Role-based access control (RBAC) in a future release {{% gh 11579 %}}.

Bug fixes and other improvements

• Improve the reliability of SSH tunnel connections in the presence of short idle TCP connection timeouts.