From: Sandy Spence <axs@aber.ac.uk>
To: 'Rajesh Kumar Mallah' <mallah.rajesh@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trigger trouble
Date: Fri, 22 Dec 2006 09:44:05 -0000
Message-ID: <000801c725ad$b8299010$520b3cc1@pc2axs> (raw)
In-Reply-To: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com>
Hi Rajesh,
I ran the select query
SELECT typowner from pg_type where typname='trigger';
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: axs@aber.ac.uk, mallah.rajesh@gmail.com
Subject: Re: Trigger trouble
In-Reply-To: <000801c725ad$b8299010$520b3cc1@pc2axs>
References: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com> <000801c725ad$b8299010$520b3cc1@pc2axs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox