Re: Urgent Support Need

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(at)postgres(dot)rocks> wrote:

>
>
> On Fri, 20 Aug 2021 at 11:17, Sunil Choudhary <
> choudhary(dot)sunil0415(at)gmail(dot)com> 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
>
>>
>>>