-- Earn every builtin achievement with a single role, including the meta -- achievements. Repetitive events are generated with \gexec. CREATE ROLE t_all SUPERUSER LOGIN; \c - t_all NOTICE: [BRONZE] Achievement unlocked: Welcome (+10) DETAIL: Connect to the server for the first time. Total score: 10. Unlocked by 2 of 9 players (22%). \set QUIET on \o /dev/null -- bronze SELECT 1; NOTICE: [BRONZE] Achievement unlocked: Hello, World (+10) DETAIL: Run your first SELECT. Total score: 20. Unlocked by 9 of 9 players (100%). CREATE TABLE a_t (id int, j jsonb); NOTICE: [BRONZE] Achievement unlocked: First Table (+10) DETAIL: Create your first table. Total score: 30. Unlocked by 4 of 9 players (44%). CREATE INDEX ON a_t (id); NOTICE: [BRONZE] Achievement unlocked: Indexer (+10) DETAIL: Create your first index. Total score: 40. Unlocked by 2 of 9 players (22%). CREATE FUNCTION a_f() RETURNS int LANGUAGE sql AS 'SELECT 1'; NOTICE: [BRONZE] Achievement unlocked: Functionary (+10) DETAIL: Create your first function or procedure. Total score: 50. Unlocked by 3 of 9 players (33%). WITH x AS (SELECT 1) SELECT * FROM x; NOTICE: [BRONZE] Achievement unlocked: WITH Love (+10) DETAIL: Run a query with a common table expression. Total score: 60. Unlocked by 3 of 9 players (33%). SELECT 1 FROM a_t JOIN a_t b USING (id); NOTICE: [BRONZE] Achievement unlocked: All Connected (+10) DETAIL: Run a query with an explicit JOIN. Total score: 70. Unlocked by 3 of 9 players (33%). EXPLAIN SELECT 1; NOTICE: [BRONZE] Achievement unlocked: Investigator (+10) DETAIL: Ask the planner with EXPLAIN. Total score: 80. Unlocked by 2 of 9 players (22%). SET pg_achievements.notify = off; -- see 04_errors SELECT 'SELEC ' || g FROM generate_series(1, 10) g \gexec SELEC 1 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 1 ^ SELEC 2 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 2 ^ SELEC 3 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 3 ^ SELEC 4 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 4 ^ SELEC 5 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 5 ^ SELEC 6 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 6 ^ SELEC 7 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 7 ^ SELEC 8 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 8 ^ SELEC 9 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 9 ^ SELEC 10 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 10 ^ RESET pg_achievements.notify; SELECT 'SELECT * FROM a_t' FROM generate_series(1, 1000) \gexec SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [BRONZE] Achievement unlocked: Stargazer (+10) DETAIL: Run 100 queries with SELECT *. Total score: 100. You are the first of 9 players to unlock it. SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [SILVER] Achievement unlocked: A Thousand and One Queries (+25) DETAIL: Run 1001 SELECT statements. Total score: 125. You are the first of 9 players to unlock it. SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [SILVER] Achievement unlocked: Star Veteran (+25) DETAIL: Run 1000 queries with SELECT *. Total score: 150. You are the first of 9 players to unlock it. SELECT * FROM a_t SET pg_achievements.test_now = '2026-11-18 04:00:00-08'; SELECT 'SELECT 1' FROM generate_series(1, 20) \gexec NOTICE: [BRONZE] Achievement unlocked: Night Owl (+10) DETAIL: Run a query between 03:00 and 05:00. Total score: 160. Unlocked by 2 of 9 players (22%). SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 NOTICE: [SILVER] Achievement unlocked: Night Shift (+25) DETAIL: Run 20 queries between 03:00 and 05:00. Total score: 185. You are the first of 9 players to unlock it. SELECT 1 RESET pg_achievements.test_now; SELECT 1 FROM a_t WHERE id = NULL; NOTICE: [BRONZE] Achievement unlocked: NULL Is Not Equal to NULL (+10) DETAIL: Compare with = NULL instead of IS NULL. Total score: 195. Unlocked by 2 of 9 players (22%). -- silver EXPLAIN ANALYZE SELECT 1; NOTICE: [SILVER] Achievement unlocked: Detective (+25) DETAIL: Run EXPLAIN ANALYZE. Total score: 220. Unlocked by 2 of 9 players (22%). WITH RECURSIVE r AS (SELECT 1 UNION SELECT 1 FROM r) SELECT * FROM r; NOTICE: [SILVER] Achievement unlocked: Recursion: See Recursion (+25) DETAIL: Run a WITH RECURSIVE query. Total score: 245. Unlocked by 2 of 9 players (22%). SELECT row_number() OVER () FROM a_t; NOTICE: [SILVER] Achievement unlocked: Open Window (+25) DETAIL: Use a window function. Total score: 270. Unlocked by 2 of 9 players (22%). SELECT * FROM a_t, LATERAL (SELECT a_t.id) s; NOTICE: [SILVER] Achievement unlocked: Lateral Thinking (+25) DETAIL: Use LATERAL. Total score: 295. Unlocked by 2 of 9 players (22%). SELECT j -> 'a', j -> 'b', j ->> 'c', j ->> 'd', j @> '{}', j ? 'e', j -> 'f', j -> 'g', j -> 'h', j -> 'i' FROM a_t; NOTICE: [SILVER] Achievement unlocked: JSONB Juggler (+25) DETAIL: Use the JSONB operators ->, ->>, @> or ? 10 times. Total score: 320. You are the first of 9 players to unlock it. SET pg_achievements.test_time_shift = 3601; SELECT 1; NOTICE: [SILVER] Achievement unlocked: Patient (+25) DETAIL: Wait for a query that runs longer than a minute. Total score: 345. Unlocked by 2 of 9 players (22%). NOTICE: [GOLD] Achievement unlocked: Marathon (+50) DETAIL: Wait for a query that runs longer than an hour. Total score: 395. Unlocked by 2 of 9 players (22%). BEGIN; ROLLBACK; NOTICE: [BRONZE] Achievement unlocked: Ctrl+Z (+10) DETAIL: Roll back a transaction with ROLLBACK. Total score: 405. Unlocked by 4 of 9 players (44%). NOTICE: [GOLD] Achievement unlocked: Time Machine (+50) DETAIL: Roll back a transaction that ran for over an hour. Total score: 455. Unlocked by 2 of 9 players (22%). RESET pg_achievements.test_time_shift; CREATE INDEX CONCURRENTLY ON a_t (j); NOTICE: [SILVER] Achievement unlocked: No Locks (+25) DETAIL: Create an index CONCURRENTLY. Total score: 480. Unlocked by 2 of 9 players (22%). CREATE FUNCTION a_trg() RETURNS trigger LANGUAGE plpgsql AS 'BEGIN RETURN NEW; END'; CREATE TRIGGER a_trg BEFORE INSERT ON a_t FOR EACH ROW EXECUTE FUNCTION a_trg(); NOTICE: [SILVER] Achievement unlocked: Trigger Happy (+25) DETAIL: Create a trigger. Total score: 505. Unlocked by 2 of 9 players (22%). CREATE TABLE a_p (id int) PARTITION BY LIST (id); NOTICE: [SILVER] Achievement unlocked: Divide and Conquer (+25) DETAIL: Create a partitioned table or a partition. Total score: 530. Unlocked by 2 of 9 players (22%). CREATE EXTENSION pg_stat_statements; DROP EXTENSION pg_stat_statements; CREATE EXTENSION pg_stat_statements; DROP EXTENSION pg_stat_statements; CREATE EXTENSION pg_stat_statements; NOTICE: [SILVER] Achievement unlocked: Expanding Horizons (+25) DETAIL: Create 3 extensions. Total score: 555. You are the first of 9 players to unlock it. DROP EXTENSION pg_stat_statements; -- gold UPDATE a_t SET id = id; NOTICE: [GOLD] Achievement unlocked: Forgot WHERE (+50) DETAIL: UPDATE without a WHERE clause. Total score: 605. Unlocked by 3 of 9 players (33%). DELETE FROM a_t; NOTICE: [GOLD] Achievement unlocked: Forgot WHERE, Part 2 (+50) DETAIL: DELETE without a WHERE clause. Total score: 655. Unlocked by 2 of 9 players (22%). SET pg_achievements.notify = off; SELECT 'DO $$ BEGIN RAISE EXCEPTION ''x'' USING ERRCODE = ''40P01''; END $$' FROM generate_series(1, 5) \gexec DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40001'; END $$; ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE RESET pg_achievements.notify; SET pg_achievements.test_now = '2026-11-20 20:00:00-08'; CREATE TABLE a_friday (id int); NOTICE: [GOLD] Achievement unlocked: Friday Deploy (+50) DETAIL: Run DDL on a Friday after 18:00. Total score: 855. Unlocked by 2 of 9 players (22%). RESET pg_achievements.test_now; CREATE TABLE a_big AS SELECT generate_series(1, 2000) AS id; ANALYZE a_big; SELECT count(*) FROM a_big; NOTICE: [GOLD] Achievement unlocked: Indexes Are for the Weak (+50) DETAIL: Scan a table of a million rows sequentially. Total score: 905. Unlocked by 2 of 9 players (22%). SELECT pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1) FROM generate_series(1, 0); NOTICE: [GOLD] Achievement unlocked: Executioner (+50) DETAIL: Call pg_terminate_backend. Total score: 955. Unlocked by 2 of 9 players (22%). NOTICE: [GOLD] Achievement unlocked: Serial Executioner (+50) DETAIL: Call pg_terminate_backend 10 times. Total score: 1005. You are the first of 9 players to unlock it. TRUNCATE a_t; NOTICE: [GOLD] Achievement unlocked: Clean Slate (+50) DETAIL: TRUNCATE a table. Total score: 1055. Unlocked by 3 of 9 players (33%). VACUUM FULL a_t; NOTICE: [GOLD] Achievement unlocked: Master of the Table (+50) DETAIL: Run VACUUM FULL. Total score: 1105. Unlocked by 2 of 9 players (22%). SELECT 1 FROM a_t t0 JOIN a_t t1 USING (id) JOIN a_t t2 USING (id) JOIN a_t t3 USING (id) JOIN a_t t4 USING (id) JOIN a_t t5 USING (id) JOIN a_t t6 USING (id) JOIN a_t t7 USING (id) JOIN a_t t8 USING (id) JOIN a_t t9 USING (id) JOIN a_t t10 USING (id); NOTICE: [GOLD] Achievement unlocked: JOINs Without Borders (+50) DETAIL: Run a query with 8 JOINs. Total score: 1155. You are the first of 9 players to unlock it. NOTICE: [GOLD] Achievement unlocked: Ten JOINs (+50) DETAIL: Run a query with 10 JOINs. Total score: 1205. You are the first of 9 players to unlock it. SELECT format('CREATE TABLE a_many_%s ()', g) FROM generate_series(1, 100) g \gexec CREATE TABLE a_many_1 () CREATE TABLE a_many_2 () CREATE TABLE a_many_3 () CREATE TABLE a_many_4 () CREATE TABLE a_many_5 () CREATE TABLE a_many_6 () CREATE TABLE a_many_7 () CREATE TABLE a_many_8 () CREATE TABLE a_many_9 () CREATE TABLE a_many_10 () CREATE TABLE a_many_11 () CREATE TABLE a_many_12 () CREATE TABLE a_many_13 () CREATE TABLE a_many_14 () CREATE TABLE a_many_15 () CREATE TABLE a_many_16 () CREATE TABLE a_many_17 () CREATE TABLE a_many_18 () CREATE TABLE a_many_19 () CREATE TABLE a_many_20 () CREATE TABLE a_many_21 () CREATE TABLE a_many_22 () CREATE TABLE a_many_23 () CREATE TABLE a_many_24 () CREATE TABLE a_many_25 () CREATE TABLE a_many_26 () CREATE TABLE a_many_27 () CREATE TABLE a_many_28 () CREATE TABLE a_many_29 () CREATE TABLE a_many_30 () CREATE TABLE a_many_31 () CREATE TABLE a_many_32 () CREATE TABLE a_many_33 () CREATE TABLE a_many_34 () CREATE TABLE a_many_35 () CREATE TABLE a_many_36 () CREATE TABLE a_many_37 () CREATE TABLE a_many_38 () CREATE TABLE a_many_39 () CREATE TABLE a_many_40 () CREATE TABLE a_many_41 () CREATE TABLE a_many_42 () CREATE TABLE a_many_43 () CREATE TABLE a_many_44 () CREATE TABLE a_many_45 () CREATE TABLE a_many_46 () CREATE TABLE a_many_47 () CREATE TABLE a_many_48 () CREATE TABLE a_many_49 () CREATE TABLE a_many_50 () CREATE TABLE a_many_51 () CREATE TABLE a_many_52 () CREATE TABLE a_many_53 () CREATE TABLE a_many_54 () CREATE TABLE a_many_55 () CREATE TABLE a_many_56 () CREATE TABLE a_many_57 () CREATE TABLE a_many_58 () CREATE TABLE a_many_59 () CREATE TABLE a_many_60 () CREATE TABLE a_many_61 () CREATE TABLE a_many_62 () CREATE TABLE a_many_63 () CREATE TABLE a_many_64 () CREATE TABLE a_many_65 () CREATE TABLE a_many_66 () CREATE TABLE a_many_67 () CREATE TABLE a_many_68 () CREATE TABLE a_many_69 () CREATE TABLE a_many_70 () CREATE TABLE a_many_71 () CREATE TABLE a_many_72 () CREATE TABLE a_many_73 () CREATE TABLE a_many_74 () CREATE TABLE a_many_75 () CREATE TABLE a_many_76 () CREATE TABLE a_many_77 () CREATE TABLE a_many_78 () CREATE TABLE a_many_79 () CREATE TABLE a_many_80 () CREATE TABLE a_many_81 () CREATE TABLE a_many_82 () CREATE TABLE a_many_83 () CREATE TABLE a_many_84 () CREATE TABLE a_many_85 () CREATE TABLE a_many_86 () CREATE TABLE a_many_87 () CREATE TABLE a_many_88 () CREATE TABLE a_many_89 () CREATE TABLE a_many_90 () CREATE TABLE a_many_91 () CREATE TABLE a_many_92 () CREATE TABLE a_many_93 () CREATE TABLE a_many_94 () CREATE TABLE a_many_95 () CREATE TABLE a_many_96 () NOTICE: [GOLD] Achievement unlocked: Table Collector (+50) DETAIL: Create 100 tables. Total score: 1255. You are the first of 9 players to unlock it. CREATE TABLE a_many_97 () CREATE TABLE a_many_98 () CREATE TABLE a_many_99 () CREATE TABLE a_many_100 () CREATE DATABASE a_db; DROP DATABASE a_db; NOTICE: [GOLD] Achievement unlocked: You Only Live Once (+50) DETAIL: Drop a database. Total score: 1305. Unlocked by 4 of 9 players (44%). SELECT 'DROP TABLE ' || string_agg(format('a_many_%s', g), ', ') FROM generate_series(1, 50) g \gexec DROP TABLE a_many_1, a_many_2, a_many_3, a_many_4, a_many_5, a_many_6, a_many_7, a_many_8, a_many_9, a_many_10, a_many_11, a_many_12, a_many_13, a_many_14, a_many_15, a_many_16, a_many_17, a_many_18, a_many_19, a_many_20, a_many_21, a_many_22, a_many_23, a_many_24, a_many_25, a_many_26, a_many_27, a_many_28, a_many_29, a_many_30, a_many_31, a_many_32, a_many_33, a_many_34, a_many_35, a_many_36, a_many_37, a_many_38, a_many_39, a_many_40, a_many_41, a_many_42, a_many_43, a_many_44, a_many_45, a_many_46, a_many_47, a_many_48, a_many_49, a_many_50 NOTICE: [GOLD] Achievement unlocked: Scorched Earth (+50) DETAIL: Drop 50 tables. Total score: 1355. You are the first of 9 players to unlock it. -- added in 1.1; a billion rows would take too long here, so that one is -- granted by hand (before the end: a grant awards meta achievements quietly) SELECT achievements.grant('t_all', 'billionaire'); BEGIN; ROLLBACK; INSERT INTO a_t VALUES (1) ON CONFLICT DO NOTHING; NOTICE: [BRONZE] Achievement unlocked: Upsert Happens (+10) DETAIL: Run INSERT ... ON CONFLICT. Total score: 1415. Unlocked by 2 of 9 players (22%). INSERT INTO a_t VALUES (2) RETURNING id; NOTICE: [BRONZE] Achievement unlocked: Returning Hero (+10) DETAIL: Use RETURNING in a data-modifying statement. Total score: 1425. Unlocked by 2 of 9 players (22%). COMMENT ON TABLE a_t IS 'all of them'; NOTICE: [BRONZE] Achievement unlocked: Self-Documenting (+10) DETAIL: Describe an object with COMMENT ON. Total score: 1435. Unlocked by 2 of 9 players (22%). NOTICE: [SILVER] Achievement unlocked: Collector (+25) DETAIL: Collect every bronze achievement. Total score: 1460. You are the first of 9 players to unlock it. MERGE INTO a_t USING a_t s ON a_t.id = s.id WHEN MATCHED THEN DO NOTHING; NOTICE: [SILVER] Achievement unlocked: Merge Conflict (+25) DETAIL: Run a MERGE statement. Total score: 1485. Unlocked by 2 of 9 players (22%). BEGIN; SAVEPOINT s; ROLLBACK TO s; NOTICE: [SILVER] Achievement unlocked: Save Point (+25) DETAIL: Roll back to a savepoint. Total score: 1510. Unlocked by 2 of 9 players (22%). COMMIT; CREATE MATERIALIZED VIEW a_mv AS SELECT 1 AS id; CREATE UNIQUE INDEX ON a_mv (id); REFRESH MATERIALIZED VIEW CONCURRENTLY a_mv; NOTICE: [SILVER] Achievement unlocked: Materialist (+25) DETAIL: Refresh a materialized view CONCURRENTLY. Total score: 1535. Unlocked by 2 of 9 players (22%). SELECT id FROM a_t FOR UPDATE SKIP LOCKED; NOTICE: [SILVER] Achievement unlocked: Queue Master (+25) DETAIL: Lock rows with SKIP LOCKED. Total score: 1560. Unlocked by 2 of 9 players (22%). SELECT id, count(*) FROM a_t GROUP BY ROLLUP (id); NOTICE: [SILVER] Achievement unlocked: Cube Master (+25) DETAIL: Use GROUPING SETS, ROLLUP or CUBE. Total score: 1585. Unlocked by 2 of 9 players (22%). CREATE POLICY a_pol ON a_t USING (true); NOTICE: [SILVER] Achievement unlocked: Big Brother (+25) DETAIL: Create a row-level security policy. Total score: 1610. Unlocked by 2 of 9 players (22%). NOTIFY a_chan; NOTICE: [SILVER] Achievement unlocked: Are You Listening? (+25) DETAIL: Use LISTEN, NOTIFY or pg_notify(). Total score: 1635. Unlocked by 3 of 9 players (33%). -- 60 failing statements: one short line each SET pg_achievements.notify = off; -- see 04_errors \set ECHO none ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: relation "a_missing" does not exist at character 15 ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero ERROR: division by zero RESET pg_achievements.notify; SELECT count(*) FROM a_t, a_big; NOTICE: [GOLD] Achievement unlocked: Cartesian Explosion (+50) DETAIL: Join tables without any join condition. Total score: 1785. Unlocked by 2 of 9 players (22%). SELECT count(*) FROM a_t WHERE id NOT IN (SELECT id FROM a_big); NOTICE: [GOLD] Achievement unlocked: NOT IN Trouble (+50) DETAIL: Use NOT IN with a subquery (mind the NULLs). Total score: 1835. Unlocked by 3 of 9 players (33%). BEGIN; LOCK TABLE a_t; NOTICE: [GOLD] Achievement unlocked: Lock Hoarder (+50) DETAIL: Take an ACCESS EXCLUSIVE lock with LOCK TABLE. Total score: 1885. Unlocked by 2 of 9 players (22%). COMMIT; CREATE TABLE "a 🐘" (id int); NOTICE: [GOLD] Achievement unlocked: Unicode Artist (+50) DETAIL: Create a table with an emoji in its name. Total score: 1935. Unlocked by 2 of 9 players (22%). CREATE TABLE a_table_with_a_name_much_longer_than_sixty_three_bytes_believe_me (id int); NOTICE: identifier "a_table_with_a_name_much_longer_than_sixty_three_bytes_believe_me" will be truncated to "a_table_with_a_name_much_longer_than_sixty_three_bytes_believe_" NOTICE: [GOLD] Achievement unlocked: Novelist (+50) DETAIL: Name a table so long that PostgreSQL truncates the name. Total score: 1985. Unlocked by 2 of 9 players (22%). SET pg_achievements.test_now = '2027-01-01 00:00:10-08'; SELECT 'happy new year'; NOTICE: [GOLD] Achievement unlocked: Happy New Query (+50) DETAIL: Run a query in the first minute of a new year. Total score: 2035. Unlocked by 2 of 9 players (22%). RESET pg_achievements.test_now; ALTER SYSTEM SET pg_achievements.enabled = off; NOTICE: [GOLD] Achievement unlocked: Regret (+50) DETAIL: Try to switch achievements off with ALTER SYSTEM. Total score: 2085. Unlocked by 2 of 9 players (22%). ALTER SYSTEM RESET pg_achievements.enabled; -- 30 days in a row; the last day completes every achievement \set ECHO none NOTICE: [GOLD] Achievement unlocked: On a Roll (+50) DETAIL: Run queries 30 days in a row. Total score: 2135. You are the first of 9 players to unlock it. NOTICE: [GOLD] Achievement unlocked: Gold Rush (+50) DETAIL: Collect every gold achievement. Total score: 2185. You are the first of 9 players to unlock it. NOTICE: [PLATINUM] Achievement unlocked: Slonik's Chosen (+300) DETAIL: Collect every other achievement. Total score: 2485. _.-""""-._ .' '. .--./ (o) (o) \.--. ( | | ) '--'\ __ /'--' '. | | .' '-.| |.-' | | | | '--' C O N G R A T U L A T I O N S You have collected all 68 achievements. Slonik bows to you: there is nothing left to unlock. HINT: Go outside, touch grass, run VACUUM. RESET pg_achievements.test_now; \o \set QUIET off SELECT achievements.sync(); sync ------ t (1 row) SELECT count(*) AS unlocked, sum(points) AS score FROM achievements.my; unlocked | score ----------+------- 68 | 2485 (1 row) SELECT code FROM achievements.progress WHERE NOT unlocked; code ------ (0 rows)