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

Commit339ce34

Browse files
committed
As if my JDBC patch hasn't already caused enough grief, there is now a
one-line change necessary. Due to the Mark Holloman "New Relkind forViews" patch, my support for views in the driver will need to be updatedto match. The change to DatabaseMetaData.getTableTypes[][] is asfollows:- {"VIEW", "(relkind='r' and relhasrules='t' and relname !~'^pg_' and relname !~ '^xinv')"},+ {"VIEW", "(relkind='v' and relname !~ '^pg_' and relname!~ '^xinv')"},Christopher Cain
1 parentcdc7170 commit339ce34

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1722,7 +1722,7 @@ public java.sql.ResultSet getTables(String catalog, String schemaPattern, String
17221722
// IMPORTANT: the query must be enclosed in ( )
17231723
privatestaticfinalStringgetTableTypes[][] = {
17241724
{"TABLE","(relkind='r' and relhasrules='f' and relname !~ '^pg_' and relname !~ '^xinv')"},
1725-
{"VIEW","(relkind='r' and relhasrules='t' and relname !~ '^pg_' and relname !~ '^xinv')"},
1725+
{"VIEW","(relkind='v' and relname !~ '^pg_' and relname !~ '^xinv')"},
17261726
{"INDEX","(relkind='i' and relname !~ '^pg_' and relname !~ '^xinx')"},
17271727
{"LARGE OBJECT","(relkind='r' and relname ~ '^xinv')"},
17281728
{"SEQUENCE","(relkind='S' and relname !~ '^pg_')"},

‎src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1722,7 +1722,7 @@ public java.sql.ResultSet getTables(String catalog, String schemaPattern, String
17221722
// IMPORTANT: the query must be enclosed in ( )
17231723
privatestaticfinalStringgetTableTypes[][] = {
17241724
{"TABLE","(relkind='r' and relhasrules='f' and relname !~ '^pg_' and relname !~ '^xinv')"},
1725-
{"VIEW","(relkind='r' and relhasrules='t' and relname !~ '^pg_' and relname !~ '^xinv')"},
1725+
{"VIEW","(relkind='v' and relname !~ '^pg_' and relname !~ '^xinv')"},
17261726
{"INDEX","(relkind='i' and relname !~ '^pg_' and relname !~ '^xinx')"},
17271727
{"LARGE OBJECT","(relkind='r' and relname ~ '^xinv')"},
17281728
{"SEQUENCE","(relkind='S' and relname !~ '^pg_')"},

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp