Error with table that exists but postgres says it doesn't

Поиск
Список
Период
Сортировка
От Chris Williams
Тема Error with table that exists but postgres says it doesn't
Дата
Msg-id 0b3801be22eb$31490300$edfe04c7@itd.sterling.com
обсуждение исходный текст
Список pgsql-general
I have a table I created and it shows up when I do the \dt from the psql prompt.  But when I try to
do a select from it I get the following.

select * from jddattdata;
ERROR:  cannot find attribute 1 of relation jddattdata

I haven't inserted any data yet.  I tried to drop the table and I get an error also.  Any way I can
clean some system table to help me fix this problem.
Thanks
---------
Chris Williams
Sterling Software
Rome, New York
Phone: (315) 336-0500
Email: chris_d_williams@sterling.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Glenn Sullivan
Дата:
Сообщение: Other user access to database
Следующее
От: "Bryan White"
Дата:
Сообщение: Re: [GENERAL] Other user access to database