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

Re: pgAdmin bug? snapshot

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Michael Shapiro" <mshapiro(at)ncsa(dot)edu>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin bug? snapshot
Date: 2003-11-19 22:17:43
Message-ID: 03AF4E498C591348A42FC93DEA9661B8720031@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Michael Shapiro [mailto:mshapiro(at)ncsa(dot)edu] 
> Sent: 19 November 2003 16:09
> To: Dave Page
> Subject: RE: [pgadmin-support] pgAdmin bug? snapshot
> 
> I have attached 2 log files. One for the snapshot 
> (pgamdin-new.log) and the other for the release (pgadmin-rel.log)
> 

Hi Michael,

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

(please run this and confirm the execution time in your tgcdb_test
database). I've added a note to the todo list to only populate the
stats/depends list boxes if the appropriate tab is selected.

Regards Dave

Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-11-19 22:55:41
Subject: Re: pgAdmin bug? snapshot
Previous:From: Andreas PflugDate: 2003-11-19 16:45:26
Subject: Re: pgAdmin bug? snapshot

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