Commit135a507

committed

Revert psql bits to display NOT VALID for FKs

These are superseded by pg_get_constraintdef's ability to display thesame when appropriate, which is a better place to do it anyway.

1 parenta31ff70 commit135a507Copy full SHA for 135a507

File tree

-7

lines changed

-7

lines changed

Lines changed: 2 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -1746,10 +1746,8 @@ describeOneTableDetails(const char *schemaname,`
`1746`	`1746`	`{`
`1747`	`1747`	`printfPQExpBuffer(&buf,`
`1748`	`1748`	`"SELECT conname,\n"`
`1749`		`-" pg_catalog.pg_get_constraintdef(r.oid, true) as condef\n");`
`1750`		`-if (pset.sversion >=90100)`
`1751`		`-appendPQExpBuffer(&buf," ,convalidated\n");`
`1752`		`-appendPQExpBuffer(&buf,"FROM pg_catalog.pg_constraint r\n"`
	`1749`	`+" pg_catalog.pg_get_constraintdef(r.oid, true) as condef\n"`
	`1750`	`+"FROM pg_catalog.pg_constraint r\n"`
`1753`	`1751`	`"WHERE r.conrelid = '%s' AND r.contype = 'f' ORDER BY 1",`
`1754`	`1752`	`oid);`
`1755`	`1753`	`result=PSQLexec(buf.data, false);`
`@@ -1768,9 +1766,6 @@ describeOneTableDetails(const char *schemaname,`
`1768`	`1766`	`PQgetvalue(result,i,0),`
`1769`	`1767`	`PQgetvalue(result,i,1));`
`1770`	`1768`
`1771`		`-if (pset.sversion >=90100&&strcmp(PQgetvalue(result,i,2),"f")==0)`
`1772`		`-appendPQExpBuffer(&buf," NOT VALID");`
`1773`		`-`
`1774`	`1769`	`printTableAddFooter(&cont,buf.data);`
`1775`	`1770`	`}`
`1776`	`1771`	`}`

Comments

(0)