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  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: pgadmin3 kinput2+canna
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: pgadmin3 stops working when trying to access/show