Re: Fw: Priority against catalog

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: Cristian Custodio <crstian(at)terra(dot)com(dot)br>
Cc: PostgresSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fw: Priority against catalog
Date: 2003-02-11 16:45:25
Message-ID: 1044981924.25889.167.camel@mouse.copelandconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Change the name of your function.

Regards,

Greg

On Tue, 2003-02-11 at 11:35, Cristian Custodio wrote:
> 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)
>
>
>
>
> ---------------------------(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)
--
Greg Copeland <greg(at)copelandconsulting(dot)net>
Copeland Computer Consulting

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-02-11 16:46:46 Re: PostgreSQL x Oracle
Previous Message Tom Lane 2003-02-11 16:44:05 Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3