pgadmin3 stops working when trying to access/show certain views

From: Christian Ruediger Bahls <cb064(at)stud(dot)uni-rostock(dot)de>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgadmin3 stops working when trying to access/show certain views
Date: 2003-07-23 02:39:37
Message-ID: 20030723023937.GA16106@qb352.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

hello ..

i develop a webapplication for my universities school of mathematical sciences

it uses postnuke(does not matter) on postgresql(this does :)

i have to make some tables available to my co-workers
so i told them to use pgadmin3(cant use pgadmin2-> we need encryption)
unfortunately it allways stops working when showing following
view(a join of subselects):

SELECT c.title AS sektion, a.title AS titel, b.degree,
b.givenname AS vor, b.familyname AS nach, b.employer AS inst,
u.givenname AS vor1, u.familyname AS nach1, u.employer AS inst1,
v.givenname AS vor2, v.familyname AS nach2, v.employer AS inst2,
w.givenname AS vor3, w.familyname AS nach3, w.employer AS inst3 FROM
(((((lectures a JOIN users b ON ((a.uid = b.uid))) JOIN dmv_sections c
ON ((a.sid = c.sid))) LEFT JOIN (SELECT lecture_coauthors.lid,
lecture_coauthors.givenname, lecture_coauthors.familyname,
lecture_coauthors.employer FROM lecture_coauthors WHERE
(lecture_coauthors.cid = 0)) u ON ((a.lid = u.lid))) LEFT JOIN (SELECT
lecture_coauthors.lid, lecture_coauthors.givenname,
lecture_coauthors.familyname, lecture_coauthors.employer FROM
lecture_coauthors WHERE (lecture_coauthors.cid = 1)) v ON ((a.lid =
v.lid))) LEFT JOIN (SELECT lecture_coauthors.lid,
lecture_coauthors.givenname, lecture_coauthors.familyname,
lecture_coauthors.employer FROM lecture_coauthors WHERE
(lecture_coauthors.cid = 2)) w ON ((a.lid = w.lid))) ORDER BY a.sid,
a.lid;

do you know of any similar problems ?
do you have a fix(that i could pull via snapshot into my debian?)?

you can find more information to reproduce this failure at:
http://dmv.math.uni-rostock.de/downloads/pgadmin3.html

thank you very much in advance
christian bahls

PS: i am not subscribed to -hackers .. so please cc to me :)

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2003-07-23 07:16:11 Re: PostgreSQL.hhp
Previous Message Hiroshi Saito 2003-07-23 02:32:38 Re: pgadmin3 kinput2+canna