diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-04-03 14:38:20 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-04-03 14:40:21 -0300 |
| commit | f56f8f8da6afd8523b4d5284e02a20ed2b33ef8d (patch) | |
| tree | e5f59afa60601ff9c2e92d7746df6dba57b73c99 /src/bin/psql/describe.c | |
| parent | 9155580fd5fc2a0cbb23376dfca7cd21f59c2c7b (diff) | |
| download | postgresql-f56f8f8da6afd8523b4d5284e02a20ed2b33ef8d.tar.gz postgresql-f56f8f8da6afd8523b4d5284e02a20ed2b33ef8d.zip | |
Support foreign keys that reference partitioned tables
Previously, while primary keys could be made on partitioned tables, it
was not possible to define foreign keys that reference those primary
keys. Now it is possible to do that.
Author: Álvaro Herrera
Reviewed-by: Amit Langote, Jesper Pedersen
Discussion: https://postgr.es/m/20181102234158.735b3fevta63msbj@alvherre.pgsql
Diffstat (limited to 'src/bin/psql/describe.c')
| -rw-r--r-- | src/bin/psql/describe.c | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 036810303a6..f7f7285acca 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -2452,9 +2452,12 @@ describeOneTableDetails(const char *schemaname, " pg_catalog.pg_get_constraintdef(r.oid, true) as condef,\n" " conrelid::pg_catalog.regclass AS ontable\n" "FROM pg_catalog.pg_constraint r\n" - "WHERE r.conrelid = '%s' AND r.contype = 'f'\n" - "ORDER BY conname;", + "WHERE r.conrelid = '%s' AND r.contype = 'f'\n", oid); + + if (pset.sversion >= 120000) + appendPQExpBuffer(&buf, " AND conparentid = 0\n"); + appendPQExpBuffer(&buf, "ORDER BY conname"); } result = PSQLexec(buf.data); |