Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6FB589FA0B7 for ; Fri, 22 Dec 2006 09:47:01 -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 30691-06 for ; Fri, 22 Dec 2006 09:46:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 0938B9F9DAD for ; Fri, 22 Dec 2006 09:46:52 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so1179904nzh for ; Fri, 22 Dec 2006 05:46:51 -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:references; b=BTJTrANkAcjJ/bYs6LTcz8DORSb2pNcuMvZk8yvUjo9IxdZlLeuF1/GAfl67hyf3YU9apWGsGRKqirU5/C5QRGKyOcbBCwpKFaxgs1L8BhuDhn5aSR9zZz7gsN8NbyTohB6zAkv/O7TQOkCuADhbEqkdl9951nBGzXQKvngaqck= Received: by 10.35.89.10 with SMTP id r10mr17291482pyl.1166795211637; Fri, 22 Dec 2006 05:46:51 -0800 (PST) Received: by 10.35.80.4 with HTTP; Fri, 22 Dec 2006 05:46:51 -0800 (PST) Message-ID: Date: Fri, 22 Dec 2006 19:16:51 +0530 From: "Rajesh Kumar Mallah" To: "Sandy Spence" Subject: Re: Trigger trouble Cc: pgsql-admin@postgresql.org In-Reply-To: <000801c725ad$b8299010$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9369_15890093.1166795211600" References: <000801c725ad$b8299010$520b3cc1@pc2axs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/296 X-Sequence-Number: 24088 ------=_Part_9369_15890093.1166795211600 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 12/22/06, Sandy Spence wrote: > Hi Rajesh, > > I ran the select query > SELECT typowner from pg_type where typname='trigger'; In my installation \dT reports the type trigger does it do so in yours? If it does not i am afraid someone else shall be able to help you better. regds mallah. psql>\dT *.trigger List of data types +------------+-----------+-------------+ | Schema | Name | Description | +------------+-----------+-------------+ | pg_catalog | "trigger" | | +------------+-----------+-------------+ (1 row) Regds mallah. > > with the following results > > > select typowner from pg_type where typname='trigger'; > typowner > ---------- > (0 rows) > > I then ran the second select query > SELECT * from pg_user; (I also changed slightly select usename, usesysid > from pg_user where usename='ltt';) > usename | usesysid > ---------+---------- > ltt | 3517 > (1 row) > > user/database is where the warning message for the trigger originates from. > > Is there something significant in the first select statement. > > Regards, > > 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 > > > -----Original Message----- > From: Rajesh Kumar Mallah [mailto:mallah.rajesh@gmail.com] > Sent: 21 December 2006 20:04 > To: Sandy Spence > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Trigger trouble > > 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 > > > > ------=_Part_9369_15890093.1166795211600 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 12/22/06, Sandy Spence <axs@aber.ac.uk> wrote:
> Hi Rajesh,
>
> I ran the select query
> SELECT typowner from  pg_type where typname='trigger';


In my installation \dT reports  the type trigger
does it do so in yours? If it does not i am afraid
someone else shall be able to help you better.
regds
mallah.

psql>\dT  *.trigger
           List of data types
+------------+-----------+-------------+
|   Schema   |   Name    | Description |
+------------+-----------+-------------+
| pg_catalog | "trigger" |             |
+------------+-----------+-------------+
(1 row)


Regds
mallah.

>
> with the following results
>
>
> select typowner from pg_type where typname='trigger';
>  typowner
> ----------
> (0 rows)
>
> I then ran the second select query
> SELECT * from pg_user; (I also changed slightly select usename, usesysid
> from pg_user where usename='ltt';)
>  usename | usesysid
> ---------+----------
>  ltt     |     3517
> (1 row)
>
> user/database is where the warning message for the trigger originates from.
>
> Is there something significant in the first select statement.
>
> Regards,
>
> 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
>
>
> -----Original Message-----
> From: Rajesh Kumar Mallah [mailto:mallah.rajesh@gmail.com ]
> Sent: 21 December 2006 20:04
> To: Sandy Spence
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Trigger trouble
>
> 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 <axs@aber.ac.uk> 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
> >
>
>
------=_Part_9369_15890093.1166795211600--