vac_update_datfrozenxid will raise "wrong tuple length" if pg_database tuple contains toast attribute.

Hi hackers, Recently, we encounter an issue that if the database grant too many roles that `datacl` toasted, vacuum freeze will fail with error "wrong tuple length". To reproduce the issue, please follow below steps: CREATE DATABASE vacuum_freeze_test; -- create helper function create or replac

回复: vac_update_datfrozenxid will raise "wrong tuple length" if pg_database tuple contains toast attribute.

Hi hackers, Can anyone help to verify this?

Is it possible to set end-of-data marker for COPY statement.

Hi hackers, As described in the doc https://www.postgresql.org/docs/current/sql-copy.html, the TEXT format recognizes backslash-period (\.) as end-of-data marker. The example below will raise an error for the line contains `\.`. CREATE TABLE test ( id int, name text, dep text ) Data in file "/

回复: Is it possible to set end-of-data marker for COPY statement.

Thanks for all your feedbacks!

Partitioned table permission question

Hi hackers, As I played with the partitioned table with GRANT, I found two questions. Let's see an example: CREATE TABLE measurement ( city_id int not null, logdate date not null, peaktempint, unitsales int ) PARTITION BY RANGE (logdate); CREATE TAB

回复: Partitioned table permission question

I see. Thanks for your explanation!