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 :)
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 |