Home > mailing lists

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

From	Abhra Kar
Subject	Re: Call sql function in psql
Date	January 19, 2018 12:58:56
Msg-id	CAFNULEcaM_GmATjwT=xFgKWvY-3QNgA23+w6v3nOguDXmAy2Kw@mail.gmail.com Whole thread Raw
In response to	Re: Call sql function in psql ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-general

Tree view

Thanks

On Thu, Jan 18, 2018 at 10:01 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

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.

pgsql-general by date:

From: Tom Lane
Date: 19 January 2018, 09:49:42
Subject: Re: warning for subquery that references a table but not its columns

From: Bjørn T Johansen
Date: 19 January 2018, 17:33:03
Subject: pgaudit?

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

Previous

Next