Re: Mysterious table that exists but doesn't exist

[John R Pierce <pierce@xxxxxxxxxxxx>]

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