Re: Postgresql 8

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of John DeSoi
> Sent: Wednesday, October 26, 2005 12:03 PM
> To: Bob Pawley
> Cc: Postgre General
> Subject: Re: [GENERAL] Postgresql 8
>
>
> On Oct 26, 2005, at 2:41 PM, Bob Pawley wrote:
>
> > I am running version 8 on Windows.
> >
> > Why do I get error messages stating that functions and/or tables do
> > not exist when these tables and functions are visible, accessible
> > and very much do exist, as called?
> >
> > Bob Pawley
> >
>
> Most likely cause is the schema_path is set wrong or the tables/
> functions have been created using quoted names (e.g. "myTable") and
> you are calling them without quotes. PostgreSQL folds identifier
> names to lower case unless you double quote them.

He could also be calling the functions with the wrong signature (e.g.
create numeric functions and then call them with doubles without using a
cast).

Without more information, trying to help is a shot in the dark.