Postgres Pro
Downloads
Home   >   mailing lists

Re: Mysterious table that exists but doesn't exist - Mailing list pgsql-general

From Dale Fukami
Subject Re: Mysterious table that exists but doesn't exist
Date
Msg-id CAAHkhS7o+uamqSZVA=BKA-O5ZXkH0XGeeDbsM+G9YYMJekZS0A@mail.gmail.com
Whole thread Raw
In response to Re: Mysterious table that exists but doesn't exist  (John R Pierce <pierce@hogranch.com>)
Responses Re: Mysterious table that exists but doesn't exist
List pgsql-general
Tree view
Tried the select with the quotes around each of the schema and table and I get the same result ("someschema"."tracked_deductibles"). I'm pretty certain they're both lowercase. Would the select from pg_tables show if they were mixed case by accident?

Dale 

On Tue, Apr 16, 2013 at 2:38 PM, John R Pierce <pierce@hogranch.com> wrote:
On 4/16/2013 1:29 PM, Dale Fukami wrote:
live=# select * from someschema.tracked_deductibles;
ERROR:  relation "someschema.tracked_deductibles" does not exist
LINE 1: select * from someschema.tracked_deductibles;
........
live=#\d
                                      List of relations
   Schema   |                            Name                             |   Type   | Owner
------------+-------------------------------------------------------------+----------+-------
<snip>
 someschema | tracked_deductibles                                         | table    | live


someschema.... any chance that has mixed case in it?    try "someschema".tracked_deductibles



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Mysterious table that exists but doesn't exist
Next
From: Ramsey Gurley
Date:
Subject: Re: JDBC driver versions