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

From: Mark <nvpostgres(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Debugging --- ERROR: function does not exist
Date: 2026-10-26 15:21:59
Message-ID: CAAm-KOteHvM+pAD5xBosRZau3Cb2Pzf8oZ0tioO-kFD2Y_MhBw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 26, 2026 at 1:47 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Mark <nvpostgres(at)gmail(dot)com> writes:
> > A sort of tangential question, how do I test a PROCEDURE with OUT
> > parameters from the psql command line?
>
> See the CALL man page, but IIRC it's "write NULL for each OUT
> parameter".
>
> regards, tom lane
>

Thanks Tom,

Yes you were right NULL must supplied for OUT parameters when CALLing
PROCEDURES

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2026-10-26 15:26:13 Re: Debugging --- ERROR: function does not exist
Previous Message Adrian Klaver 2026-10-26 14:43:23 Re: Debugging --- ERROR: function does not exist