Re: [GENERAL] Mysterious table that exists but doesn't exist

2013-04-17 Thread Dale Fukami
> > Hm ... there was a fix in 9.0.12 that might be relevant to this: > > http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=5840e3181b7e6c784fdb3aff708c4dcc2dfe551d > Whether that explains it or not, 9.0.5 is getting long in the tooth; > you really need to think about an update. Esp

Re: [GENERAL] Mysterious table that exists but doesn't exist

2013-04-17 Thread Dale Fukami
On Tue, Apr 16, 2013 at 3:04 PM, Tom Lane wrote: > Dale Fukami writes: > > I'm having a problem on a standby server (streaming replication) where a > > table seems to exist but is not queryable. Essentially a select statement > > (and drop/insert/etc) fails but \d an

Re: [GENERAL] Mysterious table that exists but doesn't exist

2013-04-16 Thread Dale Fukami
pr 16, 2013 at 2:38 PM, John R Pierce 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

[GENERAL] Mysterious table that exists but doesn't exist

2013-04-16 Thread Dale Fukami
Hi, I'm having a problem on a standby server (streaming replication) where a table seems to exist but is not queryable. Essentially a select statement (and drop/insert/etc) fails but \d and pg_tables show it exists. The table exists on the master (and is queryable) and replication is still working