Question : Suppose the following relations: match(match_id) event(match_id, seq, gt, …) There are the following indexes: match(match_id) event(match_id, seq) Further […]
Tag: postgresql-13
Why PG 13 does not allow deferring statement trigger constraints?
Question : I noticed in PG 13 docs that only row constraint triggers can be deferrable. Why not statement constraint […]
Recovery with Postgresql logical replication
Question : I’m using Postgresql 13 on Debian 10.6 and learning about logical replication. I’ve set up logical replication with […]
How to conditionally create JSON array in postgres with group by clause?
Question : I am using Postgresql 13.0 and have a table category as follows: cat_id | cat_name | piece | […]
PostgreSQL: pg_upgrade 9.5 to 13 failing with “connection to database failed: FATAL: database “template1″ does not exist”
Question : I’m trying to upgrade a 9.5 server to 13 but the pg_upgrade process is failing after the main […]
ERROR: invalid byte sequence for encoding “UTF8”: 0x00 in pg_stat_statements
Question : I’m attempting to use pg_stat_statements to optimise my queries but ran into an unexpected roadblock. SELECT total_plan_time + […]
Collation won’t set when creating new database
Question : I am trying to set the collation for a new database in PostgreSQL 13 but it does not […]
Filter table lookup by array value, but returning groupby unfiltered
Question : I have multiple lookup tables and each need to be filtered by an array of values: select array_agg(joined_properties.name) […]
POSTGRESQL Subtract to each row the previous row
Question : I’m writting a function which at some step I have query result like the following one: timestamp Consumed […]
Upgrade to PostgreSQL 13 fails
Question : I’m trying to upgrade PostgreSQL 12 cluster to version 13, with following script: /usr/lib/postgresql/13/bin/pg_upgrade –check –old-datadir=/var/lib/postgresql/12/main –new-datadir=/var/lib/postgresql/13/main –old-bindir=/usr/lib/postgresql/12/bin […]