Home > mailing lists

Re: Call sql function in psql - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Call sql function in psql
Date	January 18, 2018 22:31:17
Msg-id	CAKFQuwYZwavSSfapi-q2njqq8uboES858nc+XNG8Pb5d1FTvRw@mail.gmail.com Whole thread Raw
In response to	Call sql function in psql (Abhra Kar <abhra.kar@gmail.com>)
Responses	Re: Call sql function in psql (Abhra Kar <abhra.kar@gmail.com>)
List	pgsql-general

On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar <abhra.kar@gmail.com> wrote:

I tried to modify like

sess.createSQLQuery("select reset_all()")

This part is correct

.executeUpdate();

getting error -- org.postgresql.util.PSQLException: A result was returned when none was expected.

You need execute the above the same way you would execute "SELECT * FROM tbl"; then just ignore the result set that is returned.

David J.

From: Rob Sargent
Date: 18 January 2018, 22:27:21
Subject: Re: Call sql function in psql

From: Enrico Pirozzi
Date: 18 January 2018, 22:34:26
Subject: Re: Connection type