File tree Expand file tree Collapse file tree 1 file changed +4
-3
lines changed Expand file tree Collapse file tree 1 file changed +4
-3
lines changed Original file line number Diff line number Diff line change @@ -1059,12 +1059,13 @@ check_for_not_null_inheritance(ClusterInfo *cluster)
1059
1059
PGconn * conn = connectToServer (& old_cluster , active_db -> db_name );
1060
1060
1061
1061
res = executeQueryOrDie (conn ,
1062
- "SELECT cc.relnamespace::pg_catalog.regnamespace AS nspname, "
1063
- " cc.relname, ac.attname "
1062
+ "SELECT nspname, cc.relname, ac.attname "
1064
1063
"FROM pg_catalog.pg_inherits i, pg_catalog.pg_attribute ac, "
1065
- " pg_catalog.pg_attribute ap, pg_catalog.pg_class cc "
1064
+ " pg_catalog.pg_attribute ap, pg_catalog.pg_class cc, "
1065
+ " pg_catalog.pg_namespace nc "
1066
1066
"WHERE cc.oid = ac.attrelid AND i.inhrelid = ac.attrelid "
1067
1067
" AND i.inhparent = ap.attrelid AND ac.attname = ap.attname "
1068
+ " AND cc.relnamespace = nc.oid "
1068
1069
" AND ap.attnum > 0 and ap.attnotnull AND NOT ac.attnotnull" );
1069
1070
1070
1071
ntup = PQntuples (res );
You can’t perform that action at this time.
0 commit comments