Skip site navigation (1) Skip section navigation (2)

Re: Error in viewing properties of sequences

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-support(at)postgresql(dot)org
Cc: Walter Willmertinger <willmis(at)gmail(dot)com>
Subject: Re: Error in viewing properties of sequences
Date: 2009-11-27 08:18:14
Message-ID: 200911270918.14865.guillaume@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-support
Le vendredi 27 novembre 2009 à 08:56:21, Walter Willmertinger a écrit :
> 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
> 

Thanks for your report. It's already fixed. See 
http://code.pgadmin.org/trac/ticket/21.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

In response to

pgadmin-support by date

Next:From: Tim ClarkDate: 2009-11-28 23:27:45
Subject: Server not listening
Previous:From: Walter WillmertingerDate: 2009-11-27 07:56:21
Subject: Error in viewing properties of sequences

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group