Thanks, I'll check it out.
On Fri, Aug 20, 2021, 20:59 Dave Cramer <davecramer@postgres.rocks> wrote:
It just occurred to me that it is also possible that the search_path may be wrong. Again without more information it is difficult to say.
Can you try writing a small java program to test this out ?
ie
public static void main(String []args) throws Exception {
String url = "jdbc:postgresql://localhost:5432/test";
Properties props = new Properties();
props.setProperty("user", "test");
props.setProperty("password", "test");
try ( Connection conn = DriverManager.getConnection(url, props) ){
try ( Statement statement = conn.createStatement() ) {
try (ResultSet rs = statement.executeQuery( "select * from templates ") ){
if (rs.next())
System.out.println( "Get String: " + rs.getString(1));
}
}
}
}
}
On Fri, 20 Aug 2021 at 11:23, Dave Cramer <davecramer@postgres.rocks> wrote:
We check manually that table was exist in database on that time...there was no changes... it's work post grant access... Is there any internal calls in postgress?
With what you have provided. The connection that is producing the error is connected to a database that does not have a templates table.
Without more information there is little we can help you with.
I am not sure what you mean by "internal calls"?
Dave
