pgadmin3 stops working when trying to access/show certain views
От | Christian Ruediger Bahls |
---|---|
Тема | pgadmin3 stops working when trying to access/show certain views |
Дата | |
Msg-id | 20030723023937.GA16106@qb352.homeip.net обсуждение исходный текст |
Ответы |
Re: pgadmin3 stops working when trying to access/show
|
Список | 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 :)
В списке pgadmin-hackers по дате отправления: