pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Sandy Spence <axs@aber.ac.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trigger trouble
Date: Fri, 22 Dec 2006 19:16:51 +0530
Message-ID: <a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com> (raw)
In-Reply-To: <000801c725ad$b8299010$520b3cc1@pc2axs>
References: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com>
	<000801c725ad$b8299010$520b3cc1@pc2axs>

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
> >
>
>

view thread (10+ messages)  latest in thread

Message-ID: <a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com>
Permalink:  ../a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com

 · 

reply

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: mallah.rajesh@gmail.com, axs@aber.ac.uk
  Subject: Re: Trigger trouble
  In-Reply-To: <a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com>
  References: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com> <000801c725ad$b8299010$520b3cc1@pc2axs> <a97c77030612220546gb993a82ge55af3fc0d576121@mail.gmail.com>

* 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