| 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: | 3FBBF4ED.3040603@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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 COUNT(*) FROM
> (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
>
>
Stop!!!!
This is not the code for dependency! This is the "old constraint
trigger" detector code, which shows non-converted (pre-7.3) constraint
triggers.
I added this as a response to "where are my triggers, pgadmin2 showed
them all right" claims.
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-11-20 08:34:22 | Re: pgAdmin bug? snapshot |
| Previous Message | Dave Page | 2003-11-19 22:17:43 | Re: pgAdmin bug? snapshot |