Re: ALTER TABLE ADD COLUMN fast default
Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-01-01T16:01:32Z
Lists: pgsql-hackers
Attachments
- fast_default-v5.patch (text/x-patch) patch v5
On 12/31/2017 06:48 PM, Andrew Dunstan wrote: > > Here is a new version of the patch. It separates the missing values > constructs and logic from the default values constructs and logic. The > missing values now sit alongside the default values in tupleConstr. In > some places the separation makes the logic a good bit cleaner. > > Some of the logic is also reworked to remove an assumption that the > missing values structure is populated in attnum order, Also code to > support the missing stuctures is added to equalTupleDescs. > > We still have that one extra place where we need to call > CreateTupleDescCopyConstr instead of CreateTupleDescCopy. I haven't seen > an easy way around that. > New version of the patch that fills in the remaining piece in equalTupleDescs. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
Clean up treatment of missing default and CHECK-constraint records.
- 091e22b2e673 14.0 landed
-
Fast ALTER TABLE ADD COLUMN with a non-NULL default
- 16828d5c0273 11.0 landed
-
Fix application of identity values in some cases
- 533c5d8bddf0 11.0 cited