Received: from mail.disney.com (IDENT:0@mail.disney.com [204.128.192.15]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA61757 for ; Wed, 17 May 2000 13:13:27 -0400 (EDT) (envelope-from Patrick.Robin@disney.com) Received: from pain10.corp.disney.com (root@pain10.corp.disney.com [153.7.110.100]) by mail.disney.com (8.9.1/8.9.1) with SMTP id KAA22084 for ; Wed, 17 May 2000 10:12:22 -0700 (PDT) Received: from louie.fa.disney.com by pain.corp.disney.com with ESMTP for pgsql-general@postgresql.org; Wed, 17 May 2000 10:13:41 -0700 Received: from tweedledee.fas.fa.disney.com (tweedledee.fas.fa.disney.com [172.30.50.48]) by louie.fa.disney.com (8.9.2/8.9.2) with ESMTP id KAA02769 for ; Wed, 17 May 2000 10:13:21 -0700 (PDT) (envelope-from patrickr@fa.disney.com) Received: from fa.disney.com (ludwig.fas.fa.disney.com [153.7.112.235]) by tweedledee.fas.fa.disney.com (8.9.2/8.9.2) with ESMTP id KAA27179 for ; Wed, 17 May 2000 10:13:20 -0700 (PDT) (envelope-from patrickr@fa.disney.com) Message-Id: <3922D330.470E9451@fa.disney.com> Date: Wed, 17 May 2000 10:13:20 -0700 From: Patrick Robin X-Mailer: Mozilla 4.7 [en] (X11; U; IRIX 6.2 IP22) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: pg_dump return failed sanity check References: <14625.26748.356187.68826@localhost.grauel.com> <39223072.63596770@alumni.caltech.edu> <14626.41891.173479.250021@localhost.grauel.com> <17483.958581314@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/77 Hi, When I try to use pg_dump, I get this error. Can it have something to do with a custom type I added. I made sure I added the input/output functions and comparision functions for sorting and queries. The type works fine in SQL queries in general. > pg_dump -s scm \connect - d23adm failed sanity check, type with oid 457690 was not found Thanks Patrick -- ________________________________________ Patrick Robin patrickr@fa.disney.com Walt Disney Feature Animation 500 South Buena Vista Street Burbank,California 91521-4817