Fw: Priority against catalog - Mailing list pgsql-general

From Cristian Custodio
Subject Fw: Priority against catalog
Date
Msg-id 001301c2d1f3$f90b7150$fb01a8c0@ttcristian
Whole thread Raw
Responses Re: Fw: Priority against catalog
Re: Fw: Priority against catalog
List pgsql-general
Thanks for your answer, but I already did this.

Don't you would have another sugestion?

Cristian


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Cristian Custodio" <crstian@terra.com.br>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, February 11, 2003 12:26 PM
Subject: Re: [GENERAL] Priority against catalog


"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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




pgsql-general by date:

Previous
From: Viacheslav N Tararin
Date:
Subject: Re: Rights for view.
Next
From: Tom Lane
Date:
Subject: Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3