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 20:37:34
Message-ID: 937d27e10801311237o39db422apde903ee1fedd6a5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Jan 31, 2008 8:21 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> However, what puzzled me is why the triggers appear in psql and
> PHPPgAdmin but not in PgAdmin (they don't show up as foreign keys under
> the "Constraints" node either).

pgAdmin will hide RI constraint triggers, but it detects foreign keys
based on the dependency information (which you use adddepends to add
to an old DB) and the triggers. Older versions of pgAdmin (ie. pgAdmin
I & II), and presumably phpPgAdmin recognise the foreign keys from the
triggers used and ignore the dependency information. In theory that
can mean misidentifying triggers as RI constraints, though in reality
that's pretty unlikely.

/D

In response to

pgadmin-support by date

Next:From: Thomas H.Date: 2008-01-31 21:01:34
Subject: Re: bug: the schema oid can't be located, please refresh all schemas
Previous:From: Raymond O'DonnellDate: 2008-01-31 20:21:36
Subject: Re: Triggers?

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