Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C559F9FA0EF for ; Thu, 21 Dec 2006 06:26:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 01728-06 for ; Thu, 21 Dec 2006 06:26:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from braint.aber.ac.uk (braint.aber.ac.uk [144.124.16.42]) by postgresql.org (Postfix) with ESMTP id 8716E9FA111 for ; Thu, 21 Dec 2006 06:26:25 -0400 (AST) Received: from localhost ([127.0.0.1] helo=braint.aber.ac.uk) by braint.aber.ac.uk with esmtp (Exim 4.54) id 1GxL83-0002l1-5M for pgsql-admin@postgresql.org; Thu, 21 Dec 2006 10:26:23 +0000 Received: from pc2axs.dcs.aber.ac.uk ([193.60.11.82] helo=pc2axs) by braint.aber.ac.uk with esmtp (Exim 4.54) id 1GxL7q-0002jc-5z for pgsql-admin@postgresql.org; Thu, 21 Dec 2006 10:26:10 +0000 From: "Sandy Spence" To: Subject: Trigger trouble Date: Thu, 21 Dec 2006 10:26:29 -0000 Message-ID: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acck6noGswDuU51RTbO7aDj3eD0NAg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Sophos-Scanned: from axs@aber.ac.uk virus scanned OK X-UWA-Mid: 1GxL7q-0002jc-5z X-UWA-Originating-IP: 193.60.11.82 X-UWA-Bounce-Filter: tbCSwasSUw X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/285 X-Sequence-Number: 24077 Hi All, I get the following error when performing a pg_dump dumping database "ltt"... pg_dump: WARNING: owner of data type trigger appears to be invalid the owner and database exists, I have run the following select statement, select pg_class.oid, pg_trigger.tgrelid from pg_trigger left join pg_class on pg_trigger.tgrelid=pg_class.oid; oid | tgrelid ---------+--------- 1260 | 1260 6081779 | 6081779 6081981 | 6081981 6081779 | 6081779 6081779 | 6081779 6081981 | 6081981 6081975 | 6081975 6081975 | 6081975 6082027 | 6082027 6081779 | 6081779 6081779 | 6081779 6082027 | 6082027 6121607 | 6121607 6121268 | 6121268 6121268 | 6121268 so it appears that it is not a dropped table causing the warning, is there any other way I can try to determine how this warning is being produced, is there a way of viewing the contents of the trigger? Thanks in advance, Sandy Computer Officer, RA Certification Manager Department of Computer Science - UWA Llandinam Building Penglais Campus Aberystwyth Ceredigion Wales - UK SY23 3DB Tel: (01970)-622433 Fax: (01970)-628536