Hi Lee,
Thanks for the ideas...
Lee Wu wrote:
I had similar problem before. I was able to select from
the_missig_table.
pmacct=# SELECT * from missing_table;
ERROR: relation "missing" does not exist
pmacct=# select * from missing_table;
ERROR: relation "missing_table" does not exist
pmacct=# \d missing_table
Did not find any relation named "missing_table".
pmacct=# select count(*) from pg_class where relname='missing_table';
count
-------
0
(1 row)
pmacct=# create table missing_table(foo int);
ERROR: type "missing_table" already exists
pmacct=#
What I did to fix my problem was to vacuum the whole database by login
psql:
vacuum;
Didn't make any difference... :-(
Hope it helps!
Nope :-(
Thanks,
Wim
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
