Received: from send106.yahoomail.com (send106.yahoomail.com [205.180.60.43]) by hub.org (8.9.1/8.9.1) with SMTP id QAA10720 for ; Mon, 18 Jan 1999 16:22:00 -0500 (EST) (envelope-from molivier@yahoo.com) Message-ID: <19990118212301.16491.rocketmail@send106.yahoomail.com> Received: from [207.181.255.211] by send106.yahoomail.com; Mon, 18 Jan 1999 13:23:01 PST Date: Mon, 18 Jan 1999 13:23:01 -0800 (PST) From: Michael Olivier Subject: need help with error: cannot find attribute 1 of relation... To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hi, I'm using a temporary table within a program, and reusing it a number of times. Somehow I ended up with two of them and am getting the following error after deleting one (via pgaccess): ERROR: cannot find attribute 1 of relation __temptable1__ I've vacuum'd, which didn't help, and also looked in the file system directory (no file named __temptable1__), and tried copying another table's file there and then deleting, but that didn't work. I'm running postgresql-6.3.2-10 under RH Linux 5.1. Can someone shed some light on this for me? thanks, Michael _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com