Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4014C9FA4B2 for ; Thu, 21 Dec 2006 16:04:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 77721-01 for ; Thu, 21 Dec 2006 16:04:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id E55DF9F939E for ; Thu, 21 Dec 2006 16:04:29 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so2651761ugf for ; Thu, 21 Dec 2006 12:04:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S1MWd6STnf8X1HXMjblLunbWZsGYKKo2gSEYEPT5481cDUckOxLClMRmmGZo+fuSI4qAVtGDy2cFjjUuKoy4uuATYay9nUNrSVkEaDNR0ICaeJ2LIplWyPZ30bWj8DUzS93iEUQCTAoE/I1sj316kr060yNGwC+XNIYmXG3Wz5Y= Received: by 10.67.106.3 with SMTP id i3mr11404886ugm.1166731468474; Thu, 21 Dec 2006 12:04:28 -0800 (PST) Received: by 10.66.216.15 with HTTP; Thu, 21 Dec 2006 12:04:28 -0800 (PST) Message-ID: Date: Fri, 22 Dec 2006 01:34:28 +0530 From: "Rajesh Kumar Mallah" To: "Sandy Spence" Subject: Re: Trigger trouble Cc: pgsql-admin@postgresql.org In-Reply-To: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/292 X-Sequence-Number: 24084 Sandy, SELECT typowner from pg_type where typname='trigger'; check if typeowner exists in the column usesysid of pg_user by doing SELECT * from pg_user ; if typeowner does not exists there is a problem. regds On 12/21/06, Sandy Spence wrote: > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate >