Re: Urgent Support Need

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Urgent Support Need
Дата
Msg-id CADK3HHJtVF7Q_VqfpUGkJZ3CbagVxg8WOVerOSmkjRAV3jMh_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Urgent Support Need  (Dave Cramer <davecramer@postgres.rocks>)
Ответы Re: Urgent Support Need  (Sunil Choudhary <choudhary.sunil0415@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Urgent Support Need
Следующее
От: Sunil Choudhary
Дата:
Сообщение: Re: Urgent Support Need