Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6RCZ7f95010 for ; Fri, 27 Jul 2001 08:35:07 -0400 (EDT) (envelope-from Dave@micro-automation.net) Received: (qmail 24354 invoked from network); 27 Jul 2001 12:35:03 -0000 Received: from eboxwest.ebox.com (HELO inspiron) (206.51.23.194) by net2.micro-automation.com with SMTP; 27 Jul 2001 12:35:03 -0000 Reply-To: From: "Dave Cramer" To: "'Tom Lane'" Cc: Subject: RE: What's going on here figured it out? Date: Fri, 27 Jul 2001 08:32:23 -0400 Organization: Micro Automation Inc. Message-ID: <023501c11698$2faf4420$8201a8c0@inspiron> 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, Build 10.0.2616 In-reply-to: <26421.996213409@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Archive-Number: 200107/965 X-Sequence-Number: 13085 Thanks for everyone's input. Dumping the schema for the table was the hint. I found the trigger that was causeing it to fail. Would be nice if there was some debug mode to see what it was doing? Dave -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane Sent: July 27, 2001 1:57 AM To: Dave@micro-automation.net Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] What's going on here? Seems pretty weird. May we see the full schema for the table? "pg_dump -s -t tablename dbname" is the best way. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster