Re: pgsql: Allow a multi-row INSERT to specify DEFAULTs for a generated col

2021-08-18 Thread Tom Lane
Laurenz Albe writes: > On Sun, 2020-11-22 at 20:48 +, Tom Lane wrote: >> Allow a multi-row INSERT to specify DEFAULTs for a generated column. > Shouldn't this be backpatched? > That seems like a clear bug to me; see this report on v11: > https://stackoverflow.com/q/68834080/6464308 https://w

Re: pgsql: Allow a multi-row INSERT to specify DEFAULTs for a generated col

2021-08-18 Thread Laurenz Albe
On Sun, 2020-11-22 at 20:48 +, Tom Lane wrote: > Allow a multi-row INSERT to specify DEFAULTs for a generated column. > > One can say "INSERT INTO tab(generated_col) VALUES (DEFAULT)" and not > draw an error. But the equivalent case for a multi-row VALUES list > always threw an error, even if