| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Mark <nvpostgres(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Debugging --- ERROR: function does not exist |
| Date: | 2026-10-25 20:33:45 |
| Message-ID: | CAKFQuwb1iPRi__PjKqags9ShJYjZEiRiQKXxEwOuwPTn23TisA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Oct 25, 2026 at 4:50 AM Mark <nvpostgres(at)gmail(dot)com> wrote:
> If I run \df getsSessDbKey I get:
> Schema | Name | Result data type |
> Argument data types
> | Type
>
> --------+--------------+------------------+--------------------------------------------------------------------------------------------------------------------+------
> public | getsessdbkey | record | isessionid text, iuser text,
> ifunction text, OUT osessdbkey bigint, OUT osessret customtype, OUT
> retsessdbmess text | func
>
> Any pointers into how I can find out more about this error or hints on how
> to resolve this would be heavily appreciated?
>
Show the code you actually wrote. If you cannot do that, write similar
code that produces the same error and show that.
For that function you'd probably write something like:
select osessdbkey, osessret, retsessdbmess
into var1, var2, var3
from getsSessDbKey(isessionid, iuser, ifunction);
to execute the function and capture the three output fields.
David J.
P.S. As for the 'memory locations' comment - that seems like something you
misunderstood and thus acted upon unnecessarily.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-10-25 20:55:32 | Re: Debugging --- ERROR: function does not exist |
| Previous Message | Tom Lane | 2026-10-25 20:19:51 | Re: Debugging --- ERROR: function does not exist |