I have this error when selecting from the pg_stat_user_tables. I restarted postgres and the error went away.
Has anyone else seen this error?
Chris Barnes
[postgres@preventdb02 londiste]$ cat /data/pgsql/data/pg_log/postgresql-Tue.log
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
ERROR: missing FROM-clause entry for table "schemaname" at character 8
STATEMENT: select schemaname.relname from pg_stat_user_tables where relname like 't0050%';
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
FATAL: no pg_hba.conf entry for host "[local]", user "sudo", database "pgdb001", SSL off
LOG: received fast shutdown request
LOG: aborting any active transactions
FATAL: terminating connection due to administrator command
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2010-02-09 08:46:26 EST
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
pgdb001=# select * from pg_stat_user_tables where relname like 't0050%';
WARNING: pgstat wait timeout
relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_t
up | last_vacuum | last_autovacuum | last_analyze | last_autoanalyze
-------+------------+-----------------+----------+--------------+----------+---------------+-----------+-----------+-----------+---------------+------------+---------
---+-------------+-----------------+--------------+------------------
16516 | dbprc001 | t0050instrument | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | | | |
(1 row)
[postgres@preventdb02 londiste]$ psql
psql (8.4.2)
Type "help" for help.
postgres=# \q
All your Hotmail contacts on your phone.
Try it now.