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

From: Mark <nvpostgres(at)gmail(dot)com>
To: rob stone <floriparob(at)tpg(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Debugging --- ERROR: function does not exist
Date: 2026-10-26 10:38:04
Message-ID: CAAm-KOvwT7m9At-6S-JRNJyn4Le0dNWt6WPGUK7OAnM-CkTu2Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 26, 2026 at 5:18 AM rob stone <floriparob(at)tpg(dot)com(dot)au> wrote:

> Hello Mark,
> On Sun, 2026-10-25 at 09:00 -0400, Tom Lane wrote:
> > Mark <nvpostgres(at)gmail(dot)com> writes:
> > > I am getting the following error which has been driving me crazy:
> > > ERROR: function getsessdbkey(text, text, text, bigint, customType,
> > > text)
> > > does not exist
> >
> > (1) search_path problem, perhaps?
> > (2) are you using a CALL statement to call it?
> >
> > regards, tom lane
> >
>
> ERROR: function getsessdbkey(text, text, text, bigint, customType,
> text) does not exist
>
> When you created customType does it use any functions, and if so are
> they in the public schema?
>
> The customType is a number, text, and a few JSONs. There are no special
functions and it is in the public schema, I think I have now found the root
of my problems (which will appear elsewhere in this thread), thanks for
your comments

I like to separate code and data (except for non trivial examples) where
possible

> Regards,
> Rob
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2026-10-26 10:49:42 Re: Debugging --- ERROR: function does not exist
Previous Message KENAN ÇİFTÇİ 2026-10-26 10:26:59 Re: PostgreSQL 17 — Native Password Policy Support