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 01:34:28 +0530
Message-ID: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com> (raw)
In-Reply-To: <000d01c724ea$7a7b8110$520b3cc1@pc2axs>
References: <000d01c724ea$7a7b8110$520b3cc1@pc2axs>
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: mallah.rajesh@gmail.com, axs@aber.ac.uk
Subject: Re: Trigger trouble
In-Reply-To: <a97c77030612211204y44b28296o6164cd6564680693@mail.gmail.com>
References: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> <a97c77030612211204y44b28296o6164cd6564680693@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