Re: Priority against catalog - Mailing list pgsql-general

From Tom Lane
Subject Re: Priority against catalog
Date
Msg-id 25676.1044977199@sss.pgh.pa.us
Whole thread Raw
In response to Priority against catalog  ("Cristian Custodio" <crstian@terra.com.br>)
List pgsql-general
"Cristian Custodio" <crstian@terra.com.br> writes:
> I created a function called Version(),
> The same that there is in PostGreSQL Catalog.

> But, to call this function I'm obrigated to=20
> specific the SCHEMA.Version. I would like it
> execute my functions when I don't to specific=20=20
> the SCHEMA.

Change the SEARCH_PATH setting so your schema is in front of
pg_catalog.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Deleting orphan records
Next
From: Tom Lane
Date:
Subject: Re: Rights for view.