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

Commitfea4376

Browse files
committed
Spell SQL keywords in uppercase in pg_dump's query.
The server won't care, but let's be consistent.David Rowley.
1 parent32ceba3 commitfea4376

File tree

1 file changed

+24
-24
lines changed

1 file changed

+24
-24
lines changed

‎src/bin/pg_dump/pg_dump.c

Lines changed: 24 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -1920,32 +1920,32 @@ buildMatViewRefreshDependencies(Archive *fout)
19201920

19211921
query=createPQExpBuffer();
19221922

1923-
appendPQExpBufferStr(query,"with recursive was "
1923+
appendPQExpBufferStr(query,"WITH RECURSIVE wAS "
19241924
"( "
1925-
"select d1.objid, d2.refobjid, c2.relkindas refrelkind "
1926-
"from pg_depend d1 "
1927-
"join pg_class c1on c1.oid = d1.objid "
1928-
"and c1.relkind = 'm' "
1929-
"join pg_rewrite r1on r1.ev_class = d1.objid "
1930-
"join pg_depend d2on d2.classid = 'pg_rewrite'::regclass "
1931-
"and d2.objid = r1.oid "
1932-
"and d2.refobjid <> d1.objid "
1933-
"join pg_class c2on c2.oid = d2.refobjid "
1934-
"and c2.relkindin ('m','v') "
1935-
"where d1.classid = 'pg_class'::regclass "
1936-
"union "
1937-
"select w.objid, d3.refobjid, c3.relkind "
1938-
"from w "
1939-
"join pg_rewrite r3on r3.ev_class = w.refobjid "
1940-
"join pg_depend d3on d3.classid = 'pg_rewrite'::regclass "
1941-
"and d3.objid = r3.oid "
1942-
"and d3.refobjid <> w.refobjid "
1943-
"join pg_class c3on c3.oid = d3.refobjid "
1944-
"and c3.relkindin ('m','v') "
1925+
"SELECT d1.objid, d2.refobjid, c2.relkindAS refrelkind "
1926+
"FROM pg_depend d1 "
1927+
"JOIN pg_class c1ON c1.oid = d1.objid "
1928+
"AND c1.relkind = 'm' "
1929+
"JOIN pg_rewrite r1ON r1.ev_class = d1.objid "
1930+
"JOIN pg_depend d2ON d2.classid = 'pg_rewrite'::regclass "
1931+
"AND d2.objid = r1.oid "
1932+
"AND d2.refobjid <> d1.objid "
1933+
"JOIN pg_class c2ON c2.oid = d2.refobjid "
1934+
"AND c2.relkindIN ('m','v') "
1935+
"WHERE d1.classid = 'pg_class'::regclass "
1936+
"UNION "
1937+
"SELECT w.objid, d3.refobjid, c3.relkind "
1938+
"FROM w "
1939+
"JOIN pg_rewrite r3ON r3.ev_class = w.refobjid "
1940+
"JOIN pg_depend d3ON d3.classid = 'pg_rewrite'::regclass "
1941+
"AND d3.objid = r3.oid "
1942+
"AND d3.refobjid <> w.refobjid "
1943+
"JOIN pg_class c3ON c3.oid = d3.refobjid "
1944+
"AND c3.relkindIN ('m','v') "
19451945
") "
1946-
"select 'pg_class'::regclass::oidas classid, objid, refobjid "
1947-
"from w "
1948-
"where refrelkind = 'm'");
1946+
"SELECT 'pg_class'::regclass::oidAS classid, objid, refobjid "
1947+
"FROM w "
1948+
"WHERE refrelkind = 'm'");
19491949

19501950
res=ExecuteSqlQuery(fout,query->data,PGRES_TUPLES_OK);
19511951

0 commit comments

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