From: | Tim Wilson <wilson(at)visi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | deleted table remnants |
Date: | 2002-05-28 15:18:45 |
Message-ID: | 20020528151845.GA17240@isis.visi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi everyone,
I went through the procedure for deleting a column from one of my tables
(select data into new table, rename old table, rename new table, etc). I
recreated the sequence and all looks right.
Now I'm having trouble updated data in a different table, this query:
UPDATE location SET state = 'IA'
WHERE location_id = 18;
produces this error:
ERROR: Relation 'new_event' does not exist
My original table was called 'event' and I selected the data into a
table called 'new_event' which was subsequently renamed to 'event'. Any
idea what's wrong? I've examined every table looking for references to
'new_event', but there aren't any.
-Tim
--
Tim Wilson | Visit Sibley online: | Check out:
Henry Sibley HS | http://www.isd197.org | http://www.zope.com
W. St. Paul, MN | | http://slashdot.org
wilson(at)visi(dot)com | <dtml-var pithy_quote> | http://linux.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Wilson | 2002-05-28 17:36:03 | remnants of deleted table causing problems |
Previous Message | Sharon Cowling | 2002-05-28 06:27:45 | Re: Copy Comand question |