ALTER TABLE ... NOREWRITE option - Mailing list pgsql-hackers

From Simon Riggs
Subject ALTER TABLE ... NOREWRITE option
Date
Msg-id CA+U5nMKwhnNpLjtXJXroJvvs2izhsOf3_M=vSYyRCgjvbHwu6w@mail.gmail.com
Whole thread Raw
Responses Re: ALTER TABLE ... NOREWRITE option  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Tablespaces in the data directory
Next
From: Bruce Momjian
Date:
Subject: Re: --single-transaction hack to pg_upgrade does not work