Thread: pgadmin3 stops working when trying to access/show certain views

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

Christian Ruediger Bahls wrote:

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

Hi Christian,
this could be a problem in libpq. What happens if you execute that
select .... from pg_rule in the query tool? Will it run if you reduce
the number of selected columns (esp. ev_action)?

Regards,
Andreas

[2003-07-23 09:51] Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> Hi Christian,
> this could be a problem in libpq. What happens if you execute that
> select .... from pg_rule in the query tool? Will it run if you reduce
> the number of selected columns (esp. ev_action)?
of course querys on the command line interface work ..
(how else could i show the definitions on the webpage i provided :)

.. could it be a problem that pgadmin3 an postmaster
   are linked to different client libraries?
(pgadmin3's is from debian,
 postmasters has been build from source,
 still both are version 7.3.3)

yours
  christian bahls
  maths student
  university of rostock