From: | Charles Clavadetscher <clavadetscher(at)swisspug(dot)org> |
---|---|
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 17:54:00 |
Message-ID: | B4F6DB1B-856B-4510-91CC-BAE354F700B7@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
> On 29.08.2018, at 19:45, TalGloz <glozmantal(at)gmail(dot)com> wrote:
>
>
>> 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.
>
> Now If I execute the function locally in a query window like this:
>
> SELECT public.seal_diff_benchmark_pgsql('YW55IGNhcm5hbCBwbGVhc3VyZQ==')
>
> Then the INSERT INTO command fires and values are being inserted into the
> public.runtime_benchmark table. But when I execute the command form a Client
> code (C++) on a different pc using the libpqxx library, then everything else
> in the function works except the INSERT INTO command. I use the right
> credentials since everything else in the function works perfectly.
>
> So why is this happening?
>
> Tal
>
Tom's assumption is possibly correct. If the client does not have autocommit set then you need to explicitly commit the transaction.
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gunnlaugur Thor Briem | 2018-08-29 18:09:53 | pg_upgrade fails saying function unaccent(text) doesn't exist |
Previous Message | TalGloz | 2018-08-29 17:45:19 | RE: Executing a Function with an INSERT INTO command fails |