July 19th, 2011 by depesz | Tags: alter, alter table, alter type, pg92, postgresql, reindex | 4 comments »
On 18th of July, Robert Haas committed patch: Avoid index rebuild for no-rewrite ALTER TABLE .. ALTER TYPE. Noah Misch. Review and minor cosmetic changes by me.
March 6th, 2011 by depesz | Tags: alter, alter table, char, length, limit, pg91, postgresql, text, type, varchar | No comments »
On 12th of February, Robert Haas committed patch: Teach ALTER TABLE .. SET DATA TYPE to avoid some table rewrites. When the old type is binary coercible to the new type and the using clause does not change ...
August 8th, 2010 by depesz | Tags: alter table, lock, locks, pg91, postgresql, trigger | 2 comments »
On 28th of July, Simon Riggs committed patch which: Log Message: ----------- Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions. Avoid hard-coding lockmode used for many altering DDL commands, allowing easier future changes of lock levels. Implementation of initial analysis ...
