Talk is cheap

Show me the code!

Contribuições no core do PostgreSQL

9.6

– Add an IF NOT EXISTS option to ALTER TABLE ADD COLUMN (Fabrízio de Royes Mello)
– Reduce the lock strength needed by ALTER TABLE when setting fillfactor and autovacuum-related relation options (Fabrízio de Royes Mello, Simon Riggs)

9.5

– Allow changing of the WAL logging status of a table after creation with ALTER TABLE … SET LOGGED / UNLOGGED (Fabrízio de Royes Mello)
– Add IF NOT EXISTS clause to CREATE TABLE AS, CREATE INDEX, CREATE SEQUENCE, and CREATE MATERIALIZED VIEW (Fabrízio de Royes Mello)
– Show tablespace size in psql’s \db+ (Fabrízio de Royes Mello)

9.4

– DISCARD now also discards sequence-related state (Fabrízio de Royes Mello, Robert Haas)
– Add recovery parameter recovery_min_apply_delay to delay replication (Robert Haas, Fabrízio de Royes Mello, Simon Riggs)
– Add DISCARD SEQUENCES command to discard cached sequence-related state (Fabrízio de Royes Mello, Robert Haas)

9.3

– Add CREATE SCHEMA … IF NOT EXISTS clause (Fabrízio de Royes Mello)

9.2

– Show role password expiration dates in \du (Fabrízio de Royes Mello)
– Add pg_xlog_location_diff() to simplify WAL location comparisons (Euler Taveira de Oliveira)

8.4

– Make to_char()’s localized month/day names depend on LC_TIME, not LC_MESSAGES (Euler Taveira de Oliveira)
– Add ability to specify per-relation autovacuum and TOAST parameters in CREATE TABLE (Alvaro, Euler Taveira de Oliveira)
– Make \d on a sequence show its column values (Euler Taveira de Oliveira)
– Add column storage type and other relation options to the \d+ display (Gregory Stark, Euler Taveira de Oliveira)
– Add localization support for messages (Euler Taveira de Oliveira)

8.3

– In initdb, allow the location of the pg_xlog directory to be specified (Euler Taveira de Oliveira)

8.2

– Allow to_char() to print localized month and day names (Euler Taveira de Oliveira)

8.1

– Add USING clause to allow additional tables to be specified to DELETE (Euler Taveira de Oliveira, Neil)
– Create new reindexdb command-line utility by moving /contrib/reindexdb into the server (Euler Taveira de Oliveira)
– Add pg_postmaster_start_time() function (Euler Taveira de Oliveira, Matthias Schmidt)

8.0

– Allow changing the owners of aggregates, conversions, databases, functions, operators, operator classes, schemas, types, and tablespaces (Christopher, Euler Taveira de Oliveira)
– New Brazilian version of FAQ (Euler Taveira de Oliveira)