Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit94a9cb4

Browse files
committed
Include TableFunc references when computing expression dependencies.
The TableFunc node (i.e., XMLTABLE) includes type and collation OIDsthat might not be referenced anywhere else in the expression tree,so they need to be accounted for when extracting dependencies.Fortunately, the practical effects of this are limited, since(a) it's somewhat unlikely that people would be extractingcolumns of non-builtin types from an XML document, and (b)in many scenarios, the query would contain other referencesto such types, or functions depending on them. However, it'snot hard to construct examples wherein the existing code letsone drop a type used in XMLTABLE and thereby break a view.This is evidently an original oversight in the XMLTABLE patch,so back-patch to v10 where that came in.Discussion:https://postgr.es/m/18427.1573508501@sss.pgh.pa.us
1 parent8e4ef32 commit94a9cb4

File tree

1 file changed

+22
-0
lines changed

1 file changed

+22
-0
lines changed

‎src/backend/catalog/dependency.c

Lines changed: 22 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2055,6 +2055,28 @@ find_expr_references_walker(Node *node,
20552055
context->addrs);
20562056
}
20572057
}
2058+
elseif (IsA(node,TableFunc))
2059+
{
2060+
TableFunc*tf= (TableFunc*)node;
2061+
ListCell*ct;
2062+
2063+
/*
2064+
* Add refs for the datatypes and collations used in the TableFunc.
2065+
*/
2066+
foreach(ct,tf->coltypes)
2067+
{
2068+
add_object_address(OCLASS_TYPE,lfirst_oid(ct),0,
2069+
context->addrs);
2070+
}
2071+
foreach(ct,tf->colcollations)
2072+
{
2073+
Oidcollid=lfirst_oid(ct);
2074+
2075+
if (OidIsValid(collid)&&collid!=DEFAULT_COLLATION_OID)
2076+
add_object_address(OCLASS_COLLATION,collid,0,
2077+
context->addrs);
2078+
}
2079+
}
20582080
elseif (IsA(node,TableSampleClause))
20592081
{
20602082
TableSampleClause*tsc= (TableSampleClause*)node;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp