"Cristian Custodio" <crstian@terra.com.br> writes:
> Thanks for your answer, but I already did this.
> Don't you would have another sugestion?
It works for me, what are you doing differently?
regression=# create schema myschema;
CREATE SCHEMA
regression=# create function myschema.version() returns text as '
regression'# select ''hello there''::text;' language sql;
CREATE FUNCTION
regression=# select version();
version
------------------------------------------------------------------
PostgreSQL 7.4devel on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)
regression=# set search_path = myschema, pg_catalog;
SET
regression=# select version();
version
-------------
hello there
(1 row)
regression=#
Try looking at "show search_path" and "select current_schemas(true)"
to see what's going on.
regards, tom lane