CREATE CONSTRAINT TRIGGER in SQL pane (pgAdmin 1.14.1)

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема CREATE CONSTRAINT TRIGGER in SQL pane (pgAdmin 1.14.1)
Дата
Msg-id 4EE9F899.8060607@nsoft.lt
обсуждение исходный текст
Ответы Re: CREATE CONSTRAINT TRIGGER in SQL pane (pgAdmin 1.14.1)  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
<div class="moz-signature"><font color="#000000">Hello,<br /><br /> After installing pgAdmin 1.14.1 I have noticed that
CREATECONSTRAINT TRIGGER statements are shown in SQL pane when selecting table from treeview. Is this done on
purpose?<br/> Frankly, I find no real use of statements like:<br /> CREATE CONSTRAINT TRIGGER
"RI_ConstraintTrigger_73501293"<br/>   AFTER DELETE<br />   ON b_dok<br />   FOR EACH ROW<br />   EXECUTE PROCEDURE
"RI_FKey_cascade_del"();<br/><br /> I think the  constraint triggers should not be shown (at least by default). They
mightbe a good thing for debugging but not for administrating the DB. I support the opinion stated in</font> <a
href="http://www.pgadmin.org/support/faq.php">http://www.pgadmin.org/support/faq.php</a>:<br /><font
color="#000000"><br/> "<span class="Apple-style-span" style="color: rgb(0, 0, 0);         font-family: verdana,
helvetica,sans-serif; font-size: 14px;         font-style: normal; font-variant: normal; font-weight: normal;
letter-spacing:normal; line-height: 17px; orphans: 2;         text-align: -webkit-auto; text-indent: 0px;
text-transform:        none; white-space: normal; widows: 2; word-spacing: 0px;         -webkit-text-size-adjust: auto;
-webkit-text-stroke-width:        0px; display: inline !important; float: none; "><br /> <...><br /> pgAdmin III
considersconstraint triggers as an internal implementation detail, not interesting for the common administrator. In
fact,CREATE CONSTRAINT TRIGGER is for backward compatibility only, and shouldn't be used in newer scripts any more.
Sometools (e.g. pgAdmin II) imply this, by showing a ADD CONSTRAINT when reverse engineering, while actually the
constraintinformation in the database is missing.</span><br style="color: rgb(0, 0, 0); font-family:         verdana,
helvetica,sans-serif; font-size: 14px; font-style:         normal; font-variant: normal; font-weight: normal;
letter-spacing:normal; line-height: 17px; orphans: 2;         text-align: -webkit-auto; text-indent: 0px;
text-transform:        none; white-space: normal; widows: 2; word-spacing: 0px;         -webkit-text-size-adjust: auto;
-webkit-text-stroke-width:        0px; " /><span class="Apple-style-span" style="color: rgb(0, 0, 0);
font-family:verdana, helvetica, sans-serif; font-size: 14px;         font-style: normal; font-variant: normal;
font-weight:normal;         letter-spacing: normal; line-height: 17px; orphans: 2;         text-align: -webkit-auto;
text-indent:0px; text-transform:         none; white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-size-adjust:auto; -webkit-text-stroke-width:         0px; display: inline !important; float: none; ">Run
theadddepend script, which can be found in the backend's sources contrib/adddepend directory. [AP]</span>"<br /><br />
I'dbe glad if they disappeared from the SQL pane.</font><br /><font color="#000000"><br /> pgAdmin 1.14.1<br /> WinXp
SP3<br/> PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (Gentoo 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2<br
/></font><br/> -- <br /> Julius Tuskenis<br /> Head of the programming department<br /> UAB nSoft<br /> mob.
+37068233050</div>

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgadmin - problems with servers treeview
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: pgAgent STDERR and Time Zone Questions