MIME-Version: 1.0
Reply-To: emre@hasegeli.com
From: Emre Hasegeli <emre@hasegeli.com>
Date: Sun, 30 May 2021 16:25:23 +0300
Message-ID: 
 <CAE2gYzw0dUtL4PZ6_zfwyF9yCpejuRMWh_9gFgf3s8YEqxCN0Q@mail.gmail.com>
Subject: Note that ALTER TABLE cannot alter generated stored columns
To: pgsql-docs@postgresql.org
Content-Type: multipart/mixed; boundary="000000000000abc88d05c38c0cec"
Archived-At: 
 <https://www.postgresql.org/message-id/CAE2gYzw0dUtL4PZ6_zfwyF9yCpejuRMWh_9gFgf3s8YEqxCN0Q%40mail.gmail.com>
Precedence: bulk

--000000000000abc88d05c38c0cec
Content-Type: text/plain; charset="UTF-8"

I was trying to change the generation expression of a generated stored
column using ALTER TABLE.  It took me a while before I figured SET
GENERATED applies only to generated identity columns.  I think it'd be
useful to note this in the documentation with something like the
attached.

--000000000000abc88d05c38c0cec
Content-Type: application/octet-stream;
	name="0001-doc-Note-that-ALTER-TABLE-cannot-alter-generated-sto.patch"
Content-Disposition: attachment;
	filename="0001-doc-Note-that-ALTER-TABLE-cannot-alter-generated-sto.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_kpb7swbe0>
X-Attachment-Id: f_kpb7swbe0

RnJvbSAzZDZmZTdlNmJiNTcwODFhOWI3YzNkNWJjYzIzZTUxNTllZDY1YmE3IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBFbXJlIEhhc2VnZWxpIDxlbXJlQGhhc2VnZWxpLmNvbT4KRGF0
ZTogU3VuLCAzMCBNYXkgMjAyMSAxNjoxMTozMCArMDMwMApTdWJqZWN0OiBbUEFUQ0hdIGRvYzog
Tm90ZSB0aGF0IEFMVEVSIFRBQkxFIGNhbm5vdCBhbHRlciBnZW5lcmF0ZWQgc3RvcmVkCgpBTFRF
UiBUQUJMRSBzdXBwb3J0cyBhbHRlcmluZyBnZW5lcmF0ZWQgaWRlbnRpdHkgY29sdW1ucyB3aGlj
aCBjb3VsZApjb25mdXNlIHRoZSByZWFkZXIgYXMgdGhleSBzaGFyZSBzeW50YXggd2l0aCBnZW5l
cmF0ZWQgc3RvcmVkIGNvbHVtbnMuCkNsYXJpZnkgdGhhdCBhIGNvbHVtbiBjYW5ub3QgYmUgdHVy
bmVkIGludG8gZ2VuZXJhdGVkIHN0b3JlZCBvcgpnZW5lcmF0aW9uIGV4cHJlc3Npb25zIGNhbm5v
dCBiZSBjaGFuZ2VkIHdpdGggYSBub3RlLgotLS0KIGRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfdGFi
bGUuc2dtbCB8IDggKysrKysrKysKIDEgZmlsZSBjaGFuZ2VkLCA4IGluc2VydGlvbnMoKykKCmRp
ZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwgYi9kb2Mvc3JjL3Nn
bWwvcmVmL2FsdGVyX3RhYmxlLnNnbWwKaW5kZXggOTM5ZDNmZTI3My4uMGU5ODQ2MTUzZSAxMDA2
NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl90YWJsZS5zZ21sCisrKyBiL2RvYy9zcmMv
c2dtbC9yZWYvYWx0ZXJfdGFibGUuc2dtbApAQCAtMjUxLDIwICsyNTEsMjggQEAgV0lUSCAoIE1P
RFVMVVMgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPm51bWVyaWNfbGl0ZXJhbDwvcmVw
bGFjZWFibGU+LCBSRU0KICAgICAgIFRoaXMgZm9ybSB0dXJucyBhIHN0b3JlZCBnZW5lcmF0ZWQg
Y29sdW1uIGludG8gYSBub3JtYWwgYmFzZSBjb2x1bW4uCiAgICAgICBFeGlzdGluZyBkYXRhIGlu
IHRoZSBjb2x1bW5zIGlzIHJldGFpbmVkLCBidXQgZnV0dXJlIGNoYW5nZXMgd2lsbCBubwogICAg
ICAgbG9uZ2VyIGFwcGx5IHRoZSBnZW5lcmF0aW9uIGV4cHJlc3Npb24uCiAgICAgIDwvcGFyYT4K
IAogICAgICA8cGFyYT4KICAgICAgIElmIDxsaXRlcmFsPkRST1AgRVhQUkVTU0lPTiBJRiBFWElT
VFM8L2xpdGVyYWw+IGlzIHNwZWNpZmllZCBhbmQgdGhlCiAgICAgICBjb2x1bW4gaXMgbm90IGEg
c3RvcmVkIGdlbmVyYXRlZCBjb2x1bW4sIG5vIGVycm9yIGlzIHRocm93bi4gIEluIHRoaXMKICAg
ICAgIGNhc2UgYSBub3RpY2UgaXMgaXNzdWVkIGluc3RlYWQuCiAgICAgIDwvcGFyYT4KKworICAg
ICA8bm90ZT4KKyAgICAgIDxwYXJhPgorICAgICAgIFR1cm5pbmcgYSBjb2x1bW4gaW50byBnZW5l
cmF0ZWQgb3IgY2hhbmdpbmcgdGhlIGdlbmVyYXRpb24gZXhwcmVzc2lvbgorICAgICAgIGlzIGN1
cnJlbnRseSBub3Qgc3VwcG9ydGVkLiAgVG8gZG8gdGhhdCwgdXNlIDxjb21tYW5kPkRST1AgQ09M
VU1OPC9jb21tYW5kPgorICAgICAgIGFuZCA8Y29tbWFuZD5DUkVBVEUgQ09MVU1OPC9jb21tYW5k
PiB3aXRoIDxjb21tYW5kPkdFTkVSQVRFRCBBTFdBWVMgQVMgKCBnZW5lcmF0aW9uX2V4cHIgKSBT
VE9SRUQ8L2NvbW1hbmQ+LgorICAgICAgPC9wYXJhPgorICAgICA8L25vdGU+CiAgICAgPC9saXN0
aXRlbT4KICAgIDwvdmFybGlzdGVudHJ5PgogCiAgICA8dmFybGlzdGVudHJ5PgogICAgIDx0ZXJt
PjxsaXRlcmFsPkFERCBHRU5FUkFURUQgeyBBTFdBWVMgfCBCWSBERUZBVUxUIH0gQVMgSURFTlRJ
VFk8L2xpdGVyYWw+PC90ZXJtPgogICAgIDx0ZXJtPjxsaXRlcmFsPlNFVCBHRU5FUkFURUQgeyBB
TFdBWVMgfCBCWSBERUZBVUxUIH08L2xpdGVyYWw+PC90ZXJtPgogICAgIDx0ZXJtPjxsaXRlcmFs
PkRST1AgSURFTlRJVFkgWyBJRiBFWElTVFMgXTwvbGl0ZXJhbD48L3Rlcm0+CiAgICAgPGxpc3Rp
dGVtPgogICAgICA8cGFyYT4KICAgICAgIFRoZXNlIGZvcm1zIGNoYW5nZSB3aGV0aGVyIGEgY29s
dW1uIGlzIGFuIGlkZW50aXR5IGNvbHVtbiBvciBjaGFuZ2UgdGhlCi0tIAoyLjMwLjEgKEFwcGxl
IEdpdC0xMzApCgo=
--000000000000abc88d05c38c0cec--