From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgre General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql 8 |
Date: | 2005-10-26 18:52:00 |
Message-ID: | 435FD050.6020908@PresiNET.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
It would probably help if you supplied some more details, such as how you
"called" them, and how you tested that they are visible etc. Did you create them
enclosed in double quotes?
eg.
dev=# create table "Foo" (x date);
CREATE TABLE
dev=# select * from Foo;
ERROR: relation "foo" does not exist
dev=# select * from "Foo";
x
---
(0 rows)
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2005-10-26 18:56:08 | Re: Why database is corrupted after re-booting |
Previous Message | Dann Corbit | 2005-10-26 18:50:42 | Re: Postgresql 8 |