Received: from ae.poss.com (adam-m.poss.com [198.70.184.161]) by hub.org (8.10.1/8.10.1) with ESMTP id e8RJ9Zr58038 for ; Wed, 27 Sep 2000 15:09:35 -0400 (EDT) Received: from cmarkiewicz ([198.70.184.219]) by ae.poss.com (Netscape Messaging Server 4.1) with SMTP id G1K7XZ00.O3H for ; Wed, 27 Sep 2000 15:10:47 -0400 Reply-To: From: "chris markiewicz" To: "Postgres \(E-mail\)" Subject: sql question Date: Wed, 27 Sep 2000 15:11:34 -0400 Message-ID: <00c801c028b6$c155d2c0$dbb846c6@cmarkiewicz> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal X-Archive-Number: 200009/829 hello i just learned that some of the constraint altering functionality is not completely implemented. as a workaround, i selected all of the data from that table into a temp table, dropped and recreated the table (with the correct constraints), and now i want to re-insert the data. can this be done with a single sql stmt? thanks chris