Fw: Priority against catalog

From: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Fw: Priority against catalog
Date: 2003-02-11 17:35:27
Message-ID: 001301c2d1f3$f90b7150$fb01a8c0@ttcristian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 11, 2003 12:26 PM
Subject: Re: [GENERAL] Priority against catalog

"Cristian Custodio" <crstian(at)terra(dot)com(dot)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(at)postgresql(dot)org)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-11 17:43:18 Re: starting out
Previous Message Tom Lane 2003-02-11 17:21:56 Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3