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

Re: pgAdmin bug? snapshot

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Michael Shapiro <mshapiro(at)ncsa(dot)edu>,pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAdmin bug? snapshot
Date: 2003-11-19 22:55:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Dave Page wrote:

>By the looks of it this is Andreas' new dependency code causing this -
>in particular, the following query:
>   (SELECT tgargs from pg_trigger tr
>      LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
>      LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
>     WHERE co.oid IS NULL
>     GROUP BY tgargs
>    HAVING count(1) = 3) AS foo

This is not the code for dependency! This is the "old constraint 
trigger" detector code, which shows non-converted (pre-7.3) constraint 
I added this as a response to "where are my triggers, pgadmin2 showed 
them all right" claims.


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2003-11-20 08:34:22
Subject: Re: pgAdmin bug? snapshot
Previous:From: Dave PageDate: 2003-11-19 22:17:43
Subject: Re: pgAdmin bug? snapshot

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