Skip site navigation (1) Skip section navigation (2)

Re: Triggers?

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: rod(at)iol(dot)ie
Cc: Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Triggers?
Date: 2008-01-31 19:19:17
Message-ID: 937d27e10801311119s19993da7j1fb2bd63321d3431@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Jan 31, 2008 5:38 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> Hi all,
>
> I'm currently updating an old database that started life in PG 7.3, and
> it has a bunch of triggers for foreign key constraints, named
> "RI_ConstraintTrigger_XXXXX" and the like.
>
> While replacing these with "proper" foreign keys, I noticed that they
> don't show up in PgAdmin under the table's "Triggers" node. They do,
> however, appear in PHPPgAdmin and in psql.
>
> I'm using PgAdmin 1.8.0. Am I missing something? Or should I just
> upgrade to 1.8.1?

HI Ray,

iirc, in 7.4 and some of the other 8.x versions there was a contrib
module call adddepends which was basically a perl script which added
the required dependency information to turn the old style foreign keys
into new style. I think it's now worked it's way onto pgFoundry.

Regards, Dave

In response to

  • Triggers? at 2008-01-31 17:38:11 from Raymond O'Donnell

Responses

pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2008-01-31 20:21:36
Subject: Re: Triggers?
Previous:From: Raymond O'DonnellDate: 2008-01-31 17:38:11
Subject: Triggers?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group