Re: Urgent Support Need

Thanks, I'll check it out.

On Fri, Aug 20, 2021, 20:59 Dave Cramer <davecramer(at)postgres(dot)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(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
>>
>>>
>>>>