Additional module citext is installed, but type "citext" not found?
<p>I'm trying to run an inline query on my database - which has the <code>citext</code> extension installed (using <code>CREATE EXTENSION</code>) - and yet the executed query keeps throwing this error when calling a function:</p>

<blockquote>
<pre><code>type "citext" does not exist 
</code></pre>
</blockquote>

<pre><code>DO
LANGUAGE plpgsql
$$
DECLARE
  _id INT;
BEGIN
  SELECT * FROM "dbo"."MyFunction"(_id, 'some value'::citext);
END;
$$;
</code></pre>

<p>If I omit the <code>::citext</code> cast, it says:</p>

<blockquote>
<pre><code>function dbo.MyFunction(integer, unknown) does not exist.
You might need to add explicit type casts.
</code></pre>
</blockquote>

<p>The <code>citext</code> extension is added, is part of the schema and works with other queries. This keeps coming up randomly - what causes it?</p>

<p>EDIT:
The installed extensions:</p>

<pre><code>extname   | nspname
----------+-----------
plpgsql   | pg_catalog
citext    | public
uuid-ossp | public
</code></pre>

<p>Search path:</p>

<pre><code>show search_path;
search_path
-----------
dbo
</code></pre>