Postgres Pro
Downloads
Home   >   mailing lists

Re: Urgent Support Need - Mailing list pgsql-bugs

From Dave Cramer
Subject Re: Urgent Support Need
Date
Msg-id CADK3HHJtVF7Q_VqfpUGkJZ3CbagVxg8WOVerOSmkjRAV3jMh_w@mail.gmail.com
Whole thread Raw
In response to Re: Urgent Support Need  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Urgent Support Need  (Sunil Choudhary <choudhary.sunil0415@gmail.com>)
List pgsql-bugs
Tree view
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:


On Fri, 20 Aug 2021 at 11:17, Sunil Choudhary <choudhary.sunil0415@gmail.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

pgsql-bugs by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Urgent Support Need
Next
From: Sunil Choudhary
Date:
Subject: Re: Urgent Support Need