Re: Mysterious table that exists but doesn't exist

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Mysterious table that exists but doesn't exist
Date: 2013-04-16 20:38:34
Message-ID: 516DB6CA.4070709@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dale Fukami 2013-04-16 20:48:14 Re: Mysterious table that exists but doesn't exist
Previous Message Adrian Klaver 2013-04-16 20:36:10 Re: JDBC driver versions