Re: Mysterious table that exists but doesn't exist

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(at)hogranch(dot)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
>
>