Re: Executing a Function with an INSERT INTO command fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: TalGloz <glozmantal(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Executing a Function with an INSERT INTO command fails
Date: 2018-08-29 16:33:07
Message-ID: 21059.1535560387@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

TalGloz <glozmantal(at)gmail(dot)com> writes:
> This is very strange, even if I comment all the loops in the function and
> leave only the INSERT INTO command the insert still doesn't happen.

Maybe you're rolling back the transaction after leaving the function?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-08-29 16:34:06 Re: Executing a Function with an INSERT INTO command fails
Previous Message TalGloz 2018-08-29 16:27:06 RE: Executing a Function with an INSERT INTO command fails