Обсуждение: Error in viewing properties of sequences

Поиск
Список
Период
Сортировка

Error in viewing properties of sequences

От
Walter Willmertinger
Дата:
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
FROMpg_depend d1      LEFT JOIN pg_depend d2 ON d1.objid=d2.objid AND d1.refobjid != d2.refobjid      LEFT JOIN
pg_classref ON ref.oid = d2.refobjid      LEFT JOIN pg_attribute att ON d2.refobjid=att.attrelid AND
 
d2.refobjsubid=att.attnumWHERE d1.classid=(SELECT oid FROM pg_class WHERE relname='pg_attrdef')      AND d2.refobjid
NOTIN (SELECT d3.refobjid FROM pg_depend d3 WHERE
 
d3.objid=d1.refobjid)  AND d1.refobjid=2200::oid    


Regards
Walter

Re: Error in viewing properties of sequences

От
Guillaume Lelarge
Дата:
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.orghttp://dalibo.com