Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 54A7B9FA18F for ; Wed, 3 Jan 2007 12:03:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 37741-08 for ; Wed, 3 Jan 2007 12:03:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EFFC29F9312 for ; Wed, 3 Jan 2007 12:03:40 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l03G3RKl008119; Wed, 3 Jan 2007 11:03:27 -0500 (EST) To: "Sandy Spence" cc: "'Rajesh Kumar Mallah'" , pgsql-admin@postgresql.org Subject: Re: Trigger trouble In-reply-to: <009301c72f4e$f9bfce40$520b3cc1@pc2axs> References: <009301c72f4e$f9bfce40$520b3cc1@pc2axs> Comments: In-reply-to "Sandy Spence" message dated "Wed, 03 Jan 2007 15:51:04 +0000" Date: Wed, 03 Jan 2007 11:03:27 -0500 Message-ID: <8118.1167840207@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/12 X-Sequence-Number: 24168 "Sandy Spence" 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