Re: Postgresql 8 - Mailing list pgsql-general

From John DeSoi
Subject Re: Postgresql 8
Date
Msg-id D17FE7B8-014A-46F4-834B-C19568C4D2A1@pgedit.com
Whole thread Raw
In response to Postgresql 8  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
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.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-general by date:

Previous
From: "Welty, Richard"
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: "Dann Corbit"
Date:
Subject: Re: Postgresql 8