Error in viewing properties of sequences

[Walter Willmertinger <willmis(at)gmail(dot)com>]

Version of PgAdmin3 1.10 (rev: 7945:7946)
OS: Windows or Linux
Topic: Dependency of sequence:

Reproduce by:

Goto Database - Schemata - public - Sequences
Select a sequence
Click on the right window to the label "Dependencies"
you get a SQL syntax error for the statement:

walterw;2009-11-27 08:50:27 CETANWEISUNG:  SELECT	
	  CASE WHEN att.attname IS NOT NULL AND ref.relname IS NOT NULL THEN
ref.relname || '.' att.attname
	       ELSE ref.relname	
	  END AS refname,	
	  d2.refclassid, d1.deptype AS deptype	
	FROM pg_depend d1	
	  LEFT JOIN pg_depend d2 ON d1.objid=d2.objid AND d1.refobjid != d2.refobjid	
	  LEFT JOIN pg_class ref ON ref.oid = d2.refobjid	
	  LEFT JOIN pg_attribute att ON d2.refobjid=att.attrelid AND
d2.refobjsubid=att.attnum
	WHERE d1.classid=(SELECT oid FROM pg_class WHERE relname='pg_attrdef')	
	  AND d2.refobjid NOT IN (SELECT d3.refobjid FROM pg_depend d3 WHERE
d3.objid=d1.refobjid)
	  AND d1.refobjid=2200::oid	


Regards
Walter