prosrc => 'name_text' },

{ oid => '1402', descr => 'current schema name',

proname => 'current_schema', provolatile => 's',prorettype => 'name',

proargtypes => '', prosrc => 'current_schema' },

proname => 'current_schema', provolatile => 's',proparallel => 'u',

prorettype => 'name',proargtypes => '', prosrc => 'current_schema' },

{ oid => '1403', descr => 'current schema search list',

proname => 'current_schemas', provolatile => 's',prorettype => '_name',

proargtypes => 'bool', prosrc => 'current_schemas' },

proname => 'current_schemas', provolatile => 's',proparallel => 'u',

prorettype => '_name',proargtypes => 'bool', prosrc => 'current_schemas' },

{ oid => '1404', descr => 'substitute portion of string',

proname => 'overlay', prorettype => 'text',

ERROR: cannot PREPARE a transaction that has operated on temporary objects

-- Corner case: current_schema may create a temporary schema if namespace

-- creation is pending, so check after that. First reset the connection

-- to remove the temporary namespace, and make sure that non-parallel plans

-- are used.

-- to remove the temporary namespace.

\c -

SET max_parallel_workers = 0;

SET max_parallel_workers_per_gather = 0;

SET search_path TO 'pg_temp';

BEGIN;

SELECT current_schema() ~ 'pg_temp' AS is_temp_schema;

\c-

SET max_parallel_workers=0;

SET max_parallel_workers_per_gather=0;

SET search_path TO'pg_temp';

BEGIN;

SELECT current_schema() ~'pg_temp'AS is_temp_schema;