diff options
| author | Peter Eisentraut | 2024-03-05 10:15:06 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2024-03-05 10:24:17 +0000 |
| commit | 030e10ff1a365796bd4bcbbc5b6a8552f7efc765 (patch) | |
| tree | 2067363cf2b9941323fa0dd7e7e0fb0720957813 /src/bin/psql | |
| parent | 55cdba2647ed6bbe1126c6b6d8f53e8602ec05a1 (diff) | |
Rename pg_constraint.conwithoutoverlaps to conperiod
pg_constraint.conwithoutoverlaps was recently added to support primary
keys and unique constraints with the WITHOUT OVERLAPS clause. An
upcoming patch provides the foreign-key side of this functionality,
but the syntax there is different and uses the keyword PERIOD. It
would make sense to use the same pg_constraint field for both of
these, but then we should pick a more general name that conveys "this
constraint has a temporal/period-related feature". conperiod works
for that and is nicely compact. Changing this now avoids possibly
having to introduce versioning into clients. Note there are still
some "without overlaps" variables left, which deal specifically with
the parsing of the primary key/unique constraint feature.
Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Discussion: https://www.postgresql.org/message-id/flat/CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com
Diffstat (limited to 'src/bin/psql')
| -rw-r--r-- | src/bin/psql/describe.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index b6a4eb1d565..c05befbb6f2 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2380,9 +2380,9 @@ describeOneTableDetails(const char *schemaname, appendPQExpBufferStr(&buf, ", false AS indisreplident"); appendPQExpBufferStr(&buf, ", c2.reltablespace"); if (pset.sversion >= 170000) - appendPQExpBufferStr(&buf, ", con.conwithoutoverlaps"); + appendPQExpBufferStr(&buf, ", con.conperiod"); else - appendPQExpBufferStr(&buf, ", false AS conwithoutoverlaps"); + appendPQExpBufferStr(&buf, ", false AS conperiod"); appendPQExpBuffer(&buf, "\nFROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i\n" " LEFT JOIN pg_catalog.pg_constraint con ON (conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ('p','u','x'))\n" |