Error in viewing properties of sequences

Поиск
Список
Период
Сортировка
От Walter Willmertinger
Тема Error in viewing properties of sequences
Дата
Msg-id 8785a8f60911262356o6fe454e3je9082fc978acdf7b@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error in viewing properties of sequences  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
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


В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Bug report: pgadmin3-1.10.0 segmentation fault
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Error in viewing properties of sequences