ALTER TABLE ... NOREWRITE option

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: ALTER TABLE ... NOREWRITE option
Date: 2012-12-01 13:54:53
Message-ID: CA+U5nMKwhnNpLjtXJXroJvvs2izhsOf3_M=vSYyRCgjvbHwu6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It's hard to know whether your tables will be locked for long periods
when implementing DDL changes.

The NOREWRITE option would cause an ERROR if the table would be
rewritten by the command.

This would allow testing to highlight long running statements before
code hits production.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2012-12-01 15:25:10 Re: --single-transaction hack to pg_upgrade does not work
Previous Message Simon Riggs 2012-12-01 13:50:29 Re: Tablespaces in the data directory