Re: Call sql function in psql

2018-01-18 Thread Abhra Kar
Thanks On Thu, Jan 18, 2018 at 10:01 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar wrote: > >> >> I tried to modify like >> >> >> >> sess.createSQLQuery("select reset_all()") >> > > ​This part is correct​ > > > >> .executeUpdate()

Re: Call sql function in psql

2018-01-18 Thread David G. Johnston
On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar 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. > > >

Re: Call sql function in psql

2018-01-18 Thread Rob Sargent
> On Jan 18, 2018, at 9:22 AM, Abhra Kar wrote: > > Hi All, > > Please send me some info how to post directly in mailing > list,somwhow I am not able to find out the way so I am mailing here. > > Here is fine > > Present problem-- > > > > I tried to change b

Call sql function in psql

2018-01-18 Thread Abhra Kar
Hi All, Please send me some info how to post directly in mailing list,somwhow I am not able to find out the way so I am mailing here. Present problem-- I tried to change below code in psql — Session sess = (Session) entityManager.getDelegate(); sess.createSQLQu