> adrian.kla...@aklaver.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>> It seems that there must be different underlying mechanisms at work and that
>> this explains why creating a cursor using SQL to execute a prepared
>> statement fails but doing this using PL/pgSQL succeeds. What's going on
Thanks @Adrian Klaver
It's clear for me now.
On Sun, 16 Apr 2023, 20:13 Adrian Klaver, wrote:
> On 4/16/23 11:47, FOUTE K. Jaurès wrote:
> > Can I have an example please? Or a link
>
> create table trg_test (id integer, fld_1 varchar, fld_2 boolean);
>
>
> CREATE OR REPLACE FUNCTION
Hi
ne 16. 4. 2023 v 20:47 odesílatel FOUTE K. Jaurès
napsal:
> Can I have an example please? Or a link
>
> On Sun, 16 Apr 2023, 17:08 Pavel Stehule, wrote:
>
>> Hi
>>
>>
>> ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès
>> napsal:
>>
>>> Hello,
>>>
>>> Is it possible to call a function
On 4/16/23 11:47, FOUTE K. Jaurès wrote:
Can I have an example please? Or a link
create table trg_test (id integer, fld_1 varchar, fld_2 boolean);
CREATE OR REPLACE FUNCTION public.child_fnc(token character varying)
RETURNS void
LANGUAGE plpgsql
AS $function$
BEGIN
IF token =
Can I have an example please? Or a link
On Sun, 16 Apr 2023, 17:08 Pavel Stehule, wrote:
> Hi
>
>
> ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès
> napsal:
>
>> Hello,
>>
>> Is it possible to call a function inside a trigger function ?
>> Any idea or link are welcome. Thanks in advance
>>
On 4/16/23 11:02, Bryn Llewellyn wrote:> statement fails but doing this
using PL/pgSQL succeeds.
What's going on under the covers?
Pretty sure:
https://www.postgresql.org/docs/current/spi.html
--
Adrian Klaver
adrian.kla...@aklaver.com
> b...@yugabyte.com wrote:
>
>> david.g.johns...@gmail.com wrote:
>>
>>> b...@yugabyte.com wrote:
>>>
>>> I found this email from Peter Eisentraut:
>>> https://www.postgresql.org/message-id/762cc764-74f0-13fb-77ed-16f91c90f40d%402ndquadrant.com
>>>
>>> It caused the 42601 error, « syntax error
Hi Dear
If I have the postgres and admin 4 program running with the password that I set
from the beginning, but when I want to start the psql shell and set the same
password, it throws me the error, I send the screen I think it's self
explanatory .
I repeat that when I put the password, which
Hi
ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès
napsal:
> Hello,
>
> Is it possible to call a function inside a trigger function ?
> Any idea or link are welcome. Thanks in advance
>
sure, there is not any limit.
Regards
Pavel
>
> Best Regards
> --
> Jaurès FOUTE
>
> On 16/04/2023 17:02 CEST ertan.kucuko...@1nar.com.tr wrote:
>
> One of the systems running PostgreSQL 14.7 receive a lot of lines like in
> the subject. I have below pg_hba.conf line and that line causes these to be
> logged.
>
> host all all 0.0.0.0/0 reject
>
> If possible, I do not want to
> On 16/04/2023 16:18 CEST FOUTE K. Jaurès wrote:
>
> Is it possible to call a function inside a trigger function ?
> Any idea or link are welcome. Thanks in advance
Depends on what you want to do with the return value. Use PERFORM to ignore
the result. [0] Use SELECT INTO to handle a
Hello,
One of the systems running PostgreSQL 14.7 receive a lot of lines like in
the subject. I have below pg_hba.conf line and that line causes these to be
logged.
host all all 0.0.0.0/0 reject
If possible, I do not want to see these lines in my logs. But, I failed to
find a parameter for it.
Hello,
Is it possible to call a function inside a trigger function ?
Any idea or link are welcome. Thanks in advance
Best Regards
--
Jaurès FOUTE
13 matches
Mail list logo
