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

From: "Chris Williams" <chris_d_williams(at)itd(dot)sterling(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Error with table that exists but postgres says it doesn't
Date: 1998-12-09 13:44:46
Message-ID: 0b8401be237a$15fbfa50$edfe04c7@itd.sterling.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)sterling(dot)com

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas IZ5 1998-12-09 13:59:20 AW: AW: [HACKERS] isnull() or is it?t
Previous Message Zeugswetter Andreas IZ5 1998-12-09 10:29:32 AW: [HACKERS] isnull() or is it?t