Re: ERROR: attribute number 6 exceeds number of columns 5
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Joseph Krogh <andreas@visena.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2019-11-26T15:49:11Z
Lists: pgsql-hackers
Andreas Joseph Krogh <andreas@visena.com> writes: > Run the attached script and you'll get: > psql -f error.sql -d test > psql:error.sql:37: ERROR: attribute number 6 exceeds number of columns 5 Hmm, interesting. IMO, that *should* have thrown an error, but of course not that one. The ADD COLUMN operations are all processed in parallel, so it's not okay for one of them to have a GENERATED expression that refers to another one of the new columns. But you should have gotten a "no such column" type of error, not a run-time cross-check failure. regards, tom lane
Commits
-
Fix handling of generated columns in ALTER TABLE.
- c24f3b70efc2 12.2 landed
- 4ac8aaa36fa2 13.0 landed