diff options
| author | Andrew Dunstan | 2023-10-01 14:18:41 +0000 |
|---|---|---|
| committer | Andrew Dunstan | 2023-10-01 14:18:41 +0000 |
| commit | 276393f53efbf08f72190221e9c1ef2a28e7fc66 (patch) | |
| tree | 0a321de871c594e30bf6a9d6b3af9535206b0913 /src/backend/commands/copyfrom.c | |
| parent | b1a8dc846da4d96d903dcb5733f68a1e02d82a23 (diff) | |
Only evaluate default values as required when doing COPY FROM
Commit 9f8377f7a2 was a little too eager in fetching default values.
Normally this would not matter, but if the default value is not valid
for the type (e.g. a varchar that's too long) it caused an unnecessary
error.
Complaint and fix from Laurenz Albe
Backpatch to release 16.
Discussion: https://postgr.es/m/75a7b7483aeb331aa017328d606d568fc715b90d.camel@cybertec.at
Diffstat (limited to 'src/backend/commands/copyfrom.c')
| -rw-r--r-- | src/backend/commands/copyfrom.c | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/src/backend/commands/copyfrom.c b/src/backend/commands/copyfrom.c index 2d1567d0e42..cf0fc9d794d 100644 --- a/src/backend/commands/copyfrom.c +++ b/src/backend/commands/copyfrom.c @@ -1571,7 +1571,14 @@ BeginCopyFrom(ParseState *pstate, /* Get default info if available */ defexprs[attnum - 1] = NULL; - if (!att->attgenerated) + /* + * We only need the default values for columns that do not appear in + * the column list, unless the DEFAULT option was given. We never need + * default values for generated columns. + */ + if ((cstate->opts.default_print != NULL || + !list_member_int(cstate->attnumlist, attnum)) && + !att->attgenerated) { Expr *defexpr = (Expr *) build_column_default(cstate->rel, attnum); |