By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
| pg_rotate_logfile |
|---|
| t |
SELECT 1
CREATE EXTENSION
ERROR: could not establish connection DETAIL: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "ABCD" does not exist
CREATE FUNCTION
| readlog |
|---|
| 2026-02-28 10:23:09.784 GMT [789] FATAL: database "ABCD" does not exist 2026-02-28 10:23:09.786 GMT [788] ERROR: could not establish connection 2026-02-28 10:23:09.786 GMT [788] DETAIL: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "ABCD" does not exist 2026-02-28 10:23:09.786 GMT [788] STATEMENT: select pg_rotate_logfile(); create extension dblink; select dblink_connect('','dbname=ABCD'); |
SELECT 1