From: | Walter Willmertinger <willmis(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Error in viewing properties of sequences |
Date: | 2009-11-27 07:56:21 |
Message-ID: | 8785a8f60911262356o6fe454e3je9082fc978acdf7b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2009-11-27 08:18:14 | Re: Error in viewing properties of sequences |
Previous Message | Dave Page | 2009-11-26 12:08:30 | Re: Bug report: pgadmin3-1.10.0 segmentation fault |