pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sandy Spence <axs@aber.ac.uk>
Cc: 'Rajesh Kumar Mallah' <mallah.rajesh@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trigger trouble
Date: Wed, 03 Jan 2007 11:03:27 -0500
Message-ID: <8118.1167840207@sss.pgh.pa.us> (raw)
In-Reply-To: <009301c72f4e$f9bfce40$520b3cc1@pc2axs>
References: <009301c72f4e$f9bfce40$520b3cc1@pc2axs>

"Sandy Spence" <axs@aber.ac.uk> writes:
> when I run the select query I get the following output,

> ltt=> select * from pg_type where typname='trigger';
>  typname | typowner | typlen | typprtlen | typbyval | typtype | typisdefined
> | typdelim | typrelid | typelem | typinput | typoutput
>  | typreceive | typsend | typalign | typstorage | typdefault 
> ---------+----------+--------+-----------+----------+---------+-------------
> -+----------+----------+---------+----------+----------
> -+------------+---------+----------+------------+------------
>  trigger |        0 |      0 |         0 | f        |         | f
> |          |        0 |       0 | -        | -        
>  | -          | -       | i        | p          | trigger
> (1 row)

OK, given that column set for pg_type I guess it really is 7.2 ... you
need to think about an update real soon, because there are a whole lot
of known bugs in the version you are running.  At the very least you
should get on to the last release of the 7.2 series, which I think was
7.2.8.  But we stopped maintaining 7.2.x at all some years ago.  If you
were to move to 8.1 or 8.2 you'd find it a whole lot faster and more
stable.

Anyway, what you seem to have here is a "shell type".  It's not doing
anything useful --- you can probably just do a "DROP TYPE trigger".
Or you could just ignore the warning; it's pretty harmless.

			regards, tom lane



view thread (10+ messages)

Message-ID: <8118.1167840207@sss.pgh.pa.us>
Permalink:  ../8118.1167840207@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/8118.1167840207@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, axs@aber.ac.uk, mallah.rajesh@gmail.com
  Subject: Re: Trigger trouble
  In-Reply-To: <8118.1167840207@sss.pgh.pa.us>
  References: <009301c72f4e$f9bfce40$520b3cc1@pc2axs> <8118.1167840207@sss.pgh.pa.us>

* 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