Postgres Pro
Downloads
Home   >   mailing lists

Re: GENERATED STORED columns and table rewrites? - Mailing list pgsql-general

From Michael Lewis
Subject Re: GENERATED STORED columns and table rewrites?
Date
Msg-id CAHOFxGqUWCYuv-_C5CNBTVRgDq7LskVHPBOd1iv-5ZSW5A6UOg@mail.gmail.com
Whole thread Raw
In response to GENERATED STORED columns and table rewrites?  (Maciek Sakrejda <m.sakrejda@gmail.com>)
List pgsql-general
Tree view
Yes, the system will do a full table rewrite to compute the value and store it. Unfortunately, I believe it is an access exclusive lock during that entire time.

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: timestamp and timestamptz
Next
From: Tim Cross
Date:
Subject: Re: timestamp and timestamptz