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

From: rob stone <floriparob(at)tpg(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-26 05:18:47
Message-ID: 5400b8eae45ff245e7c0a83dcfa1293ab150db95.camel@tpg.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Rob

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yashwanth 2026-10-26 08:24:54 Query: Windows GUI Installer locale selection (English_India.1252 vs en-IN) and risk of silent index corruption when datcollversion is blank
Previous Message Durgamahesh Manne 2026-10-26 04:55:06 Re: Regarding huge logical slot lag between source and target