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 <pie...@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 > >