Re: Executing a Function with an INSERT INTO command fails

From: TalGloz <glozmantal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Executing a Function with an INSERT INTO command fails
Date: 2018-08-29 18:23:02
Message-ID: 1535566982612-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Tom's assumption is possibly correct. If the client does not have
> autocommit set then you need to explicitly commit the transaction.

I feel a little bit stupid , I forgot the use Work.commit(); in the function
on the client side!

Thanks for the help everybody!
Tal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2018-08-29 19:06:35 Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Previous Message Gunnlaugur Thor Briem 2018-08-29 18:09:53 pg_upgrade fails saying function unaccent(text) doesn't exist