Re: Debugging --- ERROR: function does not exist

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.

In response to

Responses

Browse pgsql-general by date

  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