PostgreSQL11 Archives - Page 2 of 2 - 2ndQuadrant | PostgreSQL

Posts

Upcoming Enhancements to Partitioning & Indexes in PostgreSQL 11

January 30, 2018/8 Comments/in Simon's PlanetPostgreSQL /by Simon Riggs

My colleague Alvaro Herrera has been working on a series of connected features for PostgreSQL 11. It’s worth explaining what these are rather than trying to piece together what is happening from reading commit messages. The overall idea is to allow Partitioned tables to have Referential Integrity, by way of Primary Keys and Foreign Keys, […]

PostgreSQL 11 – Server-side Procedures (Part 1)

December 7, 2017/12 Comments/in Umair's PlanetPostgreSQL /by Umair Shahid

Last week marked a rather big step in the PostgreSQL world that went largely unnoticed. Thanks to the work done by 2ndQuadrant contributors, we now have the ability to write Stored Procedures in PostgreSQL! (Ok, well not exactly now but we will have the ability once PostgreSQL 11 comes out) A procedure is essentially a […]