Thread: RI_ConstraintTrigger
hello I was diggin inet and found no answer. Since pgAdmin 14.1 (I believe), RI_ConstraintTriggers appeared in object tree. Since those are system triggers I simply don't want not to see them (usssualy number of them exceeds number of custom triggers). how to do that? After v14.1 I went back to 14.0 just to manage this. Now I tried v1.16 and I see that those triggers still exists. Of course "Show system objects in the treeeview" is unchecked. So again: how to hide thise triggers from treeview with regards. Michal Kozusznik
On Wed, 2012-06-06 at 13:48 +0200, Michal Kozusznik wrote: > hello > I was diggin inet and found no answer. Since pgAdmin 14.1 (I believe), > RI_ConstraintTriggers appeared in object tree. Yeah, it was an error, and it has been fixed (1.14.2 I would guess). > Since those are system triggers I simply don't want not to see them > (usssualy number of them exceeds number of custom triggers). > how to do that? Upgrade to 1.14.2. > After v14.1 I went back to 14.0 just to manage this. Now > I tried v1.16 and I see that those triggers still exists. Of course > "Show system objects in the treeeview" is unchecked. > > So again: how to hide thise triggers from treeview > They shouldn't be here. I've checked with 1.14.3 and 1.16 beta2, and both worked for me. So you'll need to give us more details to help us reproduce your issue. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Thanx for the answer To make test, I de-installed v1.14.0 and v1.16.0-beta. Restarted system and installed v1.14.3 Unfortunately without success. RI Constraint triggers appear in object browser, SQL pane and even in table create script. See picture at: http://img440.imageshack.us/img440/1986/pgadminbug.png We are working with: postgresql 8.4 (linux installed) pgAdmin run under Windows7 64bit best regards > They shouldn't be here. I've checked with 1.14.3 and 1.16 beta2, and > both worked for me. So you'll need to give us more details to help us > reproduce your issue. > >
On Fri, 2012-06-08 at 13:14 +0200, Michal Kozusznik wrote: > Thanx for the answer > To make test, I de-installed v1.14.0 and v1.16.0-beta. Restarted system > and installed v1.14.3 > Unfortunately without success. RI Constraint triggers appear in object > browser, SQL pane and even in table create script. > See picture at: http://img440.imageshack.us/img440/1986/pgadminbug.png > > We are working with: > postgresql 8.4 (linux installed) > pgAdmin run under Windows7 64bit > That doesn't give me any more details. I'm not yet able to reproduce the bug you may have found. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
I have exactly this same problem. As best as I can tell, the only thing that changed was I upgraded to 1.14.3.<br />I madeno changes to any options. Before 1.14.3 I did not see any RI Constraint triggers appear in object browser.<br /> I amrunning Windows 7<br /><br /><div class="gmail_quote">On Mon, Jun 18, 2012 at 3:25 AM, Guillaume Lelarge <span dir="ltr"><<ahref="mailto:guillaume@lelarge.info" target="_blank">guillaume@lelarge.info</a>></span> wrote:<br /><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Fri, 2012-06-08at 13:14 +0200, Michal Kozusznik wrote:<br /> > Thanx for the answer<br /> > To make test, I de-installedv1.14.0 and v1.16.0-beta. Restarted system<br /> > and installed v1.14.3<br /> > Unfortunately withoutsuccess. RI Constraint triggers appear in object<br /> > browser, SQL pane and even in table create script.<br/> > See picture at: <a href="http://img440.imageshack.us/img440/1986/pgadminbug.png" target="_blank">http://img440.imageshack.us/img440/1986/pgadminbug.png</a><br/> ><br /> > We are working with:<br />> postgresql 8.4 (linux installed)<br /> > pgAdmin run under Windows7 64bit<br /> ><br /><br /> That doesn't giveme any more details. I'm not yet able to reproduce the<br /> bug you may have found.<br /><span class="HOEnZb"><fontcolor="#888888"><br /><br /> --<br /> Guillaume<br /><a href="http://blog.guillaume.lelarge.info" target="_blank">http://blog.guillaume.lelarge.info</a><br/><a href="http://www.dalibo.com" target="_blank">http://www.dalibo.com</a><br/><br /><br /> --<br /> Sent via pgadmin-support mailing list (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/> To make changes to your subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support" target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></span></blockquote></div><br />
On Mon, Jun 18, 2012 at 9:31 AM, Michael Shapiro <mshapiro51@gmail.com> wrote: > I have exactly this same problem. As best as I can tell, the only thing that > changed was I upgraded to 1.14.3. > I made no changes to any options. Before 1.14.3 I did not see any RI > Constraint triggers appear in object browser. > I am running Windows 7 What database server version? I just tested here with 9.0 and 1.14.3, and I don't see the triggers, either with or without Show System Objects enabled. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
> What database server version? I just tested here with 9.0 and 1.14.3, > and I don't see the triggers, either with or without Show System > Objects enabled. > I reported it happens with postgresql 8.4 Now I checked v9.0.2 and indeed RI constraints are hidden. So looks that this issue is related only to postgresql older than 9 with regards PS. There is something wrong with mailing list configuration. I always get mailing list email address in CC field instead of "reply-to" one.
On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik <kozusznik.michal@ifortuna.cz> wrote: >> What database server version? I just tested here with 9.0 and 1.14.3, >> and I don't see the triggers, either with or without Show System >> Objects enabled. >> > > I reported it happens with postgresql 8.4 > Now I checked v9.0.2 and indeed RI constraints are hidden. > So looks that this issue is related only to postgresql older than 9 OK. Guillaume, do you have 8.4 to hand? I don't at the moment. > PS. There is something wrong with mailing list configuration. I always get > mailing list email address in CC field instead of "reply-to" one. That's correct - we intentionally don't modify the reply-to header on the PostgreSQL mailing lists. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote: > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik > <kozusznik.michal@ifortuna.cz> wrote: > >> What database server version? I just tested here with 9.0 and 1.14.3, > >> and I don't see the triggers, either with or without Show System > >> Objects enabled. > >> > > > > I reported it happens with postgresql 8.4 > > Now I checked v9.0.2 and indeed RI constraints are hidden. > > So looks that this issue is related only to postgresql older than 9 > > OK. Guillaume, do you have 8.4 to hand? I don't at the moment. > I do. I'll try to work on that ASAP. > > PS. There is something wrong with mailing list configuration. I always get > > mailing list email address in CC field instead of "reply-to" one. > > That's correct - we intentionally don't modify the reply-to header on > the PostgreSQL mailing lists. > > -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
We are running<br /><br />PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat4.1.2-51), 64-bit<br /><br /><br /><br /><div class="gmail_quote">On Mon, Jun 18, 2012 at 4:23 AM, Guillaume Lelarge <spandir="ltr"><<a href="mailto:guillaume@lelarge.info" target="_blank">guillaume@lelarge.info</a>></span> wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">OnMon, 2012-06-18 at 10:06 +0100, Dave Page wrote:<br /> > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik<br/> > <<a href="mailto:kozusznik.michal@ifortuna.cz">kozusznik.michal@ifortuna.cz</a>> wrote:<br /> >>> What database server version? I just tested here with 9.0 and 1.14.3,<br /> > >> and I don't see thetriggers, either with or without Show System<br /> > >> Objects enabled.<br /> > >><br /> > ><br/> > > I reported it happens with postgresql 8.4<br /> > > Now I checked v9.0.2 and indeed RI constraintsare hidden.<br /> > > So looks that this issue is related only to postgresql older than 9<br /> ><br/> > OK. Guillaume, do you have 8.4 to hand? I don't at the moment.<br /> ><br /><br /></div>I do. I'll tryto work on that ASAP.<br /><div class="im HOEnZb"><br /> > > PS. There is something wrong with mailing list configuration.I always get<br /> > > mailing list email address in CC field instead of "reply-to" one.<br /> ><br/> > That's correct - we intentionally don't modify the reply-to header on<br /> > the PostgreSQL mailing lists.<br/> ><br /> ><br /><br /><br /> --<br /></div><div class="im HOEnZb">Guillaume<br /><a href="http://blog.guillaume.lelarge.info"target="_blank">http://blog.guillaume.lelarge.info</a><br /><a href="http://www.dalibo.com"target="_blank">http://www.dalibo.com</a><br /><br /><br /></div><div class="HOEnZb"><div class="h5">--<br/> Sent via pgadmin-support mailing list (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/> To make changes to your subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support" target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></div></div></blockquote></div><br />
I think it is PgAdmin 1.14.3. I just uninstalled that version and reinstalled 1.14.2 and the RI-Constraints do not show up.
On Mon, Jun 18, 2012 at 5:00 AM, Michael Shapiro <mshapiro51@gmail.com> wrote:
We are running
PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bitOn Mon, Jun 18, 2012 at 4:23 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote:I do. I'll try to work on that ASAP.
> On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik
> <kozusznik.michal@ifortuna.cz> wrote:
> >> What database server version? I just tested here with 9.0 and 1.14.3,
> >> and I don't see the triggers, either with or without Show System
> >> Objects enabled.
> >>
> >
> > I reported it happens with postgresql 8.4
> > Now I checked v9.0.2 and indeed RI constraints are hidden.
> > So looks that this issue is related only to postgresql older than 9
>
> OK. Guillaume, do you have 8.4 to hand? I don't at the moment.
>
> > PS. There is something wrong with mailing list configuration. I always get
> > mailing list email address in CC field instead of "reply-to" one.
>
> That's correct - we intentionally don't modify the reply-to header on
> the PostgreSQL mailing lists.
>
>
----
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On Mon, 2012-06-18 at 05:23 -0500, Michael Shapiro wrote: > I think it is PgAdmin 1.14.3. I just uninstalled that version and > reinstalled 1.14.2 and the RI-Constraints do not show up. > We have a fix in 1.14.3 to make sure we don't display these system triggers on recent PostgreSQL releases. I guess it added a bug on older releases. Working on a fix right now. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, 18 Jun 2012 17:02:38 +0200, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Mon, 2012-06-18 at 05:23 -0500, Michael Shapiro wrote: >> I think it is PgAdmin 1.14.3. I just uninstalled that version and >> reinstalled 1.14.2 and the RI-Constraints do not show up. >> > > We have a fix in 1.14.3 to make sure we don't display these system > triggers on recent PostgreSQL releases. I guess it added a bug on older > releases. Working on a fix right now. > OK, I just pushed the fix on 1.14 branch (even if there's good chance we won't ever have a 1.14.4 release), and on master (which will be 1.16 at some point later on). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Tue, 19 Jun 2012 09:00:16 -0500, Michael Shapiro <mshapiro51@gmail.com> wrote: > Is this in the 1.14.3 which is on the download sites? > Nope. 1.14.3 is already out and won't change. You'll have to wait for the next release. The first one will probably be the next beta. -- Guillaume http://www.postgresql.fr http://dalibo.com
Thanks. I'll use 1.14.2 until the next release.<br /><br /><br /><div class="gmail_quote">On Tue, Jun 19, 2012 at 9:06 AM,Guillaume Lelarge <span dir="ltr"><<a href="mailto:guillaume@lelarge.info" target="_blank">guillaume@lelarge.info</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px#ccc solid;padding-left:1ex">On Tue, 19 Jun 2012 09:00:16 -0500, Michael Shapiro <<a href="mailto:mshapiro51@gmail.com">mshapiro51@gmail.com</a>><br/> wrote:<br /><div class="im">> Is this in the 1.14.3which is on the download sites?<br /> ><br /><br /></div>Nope. 1.14.3 is already out and won't change. You'll haveto wait for the<br /> next release. The first one will probably be the next beta.<br /><span class="HOEnZb"><font color="#888888"><br/><br /> --<br /> Guillaume<br /> <a href="http://www.postgresql.fr" target="_blank">http://www.postgresql.fr</a><br/> <a href="http://dalibo.com" target="_blank">http://dalibo.com</a><br /></font></span></blockquote></div><br/>
I suggest to use 1.14.0.<br /> Any newer version has another bug valid for postgresql 8.4: missing default values of functionarguments) which may be dangerous if you work with this feature.<br /><br /> with regards<br /><br /><blockquotecite="mid:CAGCvxeaSwKHOrZer1gKBXBi0Di09fZ-T0bzBYuBjDhnc8FDUfQ@mail.gmail.com" type="cite"> Thanks. I'll use1.14.2 until the next release.<br /></blockquote><br />
Ahh I'm stupid.<br /> 1.14.2 is OK - just checked.<br /> Sorry for making mess.<br /><br /> Dne 20.6.2012 11:09, MichalKozusznik napsal(a): <blockquote cite="mid:4FE19339.2060102@ifortuna.cz" type="cite"> I suggest to use 1.14.0.<br />Any newer version has another bug valid for postgresql 8.4: missing default values of function arguments) which may bedangerous if you work with this feature.<br /><br /> with regards<br /><br /><blockquote cite="mid:CAGCvxeaSwKHOrZer1gKBXBi0Di09fZ-T0bzBYuBjDhnc8FDUfQ@mail.gmail.com"type="cite"> Thanks. I'll use 1.14.2 until thenext release.<br /></blockquote><br /></blockquote><br />
i'm using 9.1 version can you tell me that we can use XMLTABLE in this version. if not what is the alternative for XMLTABLE..please suggest. Thanks, uday On 6/20/12, Michal Kozusznik <kozusznik.michal@ifortuna.cz> wrote: > Ahh I'm stupid. > 1.14.2 is OK - just checked. > Sorry for making mess. > > Dne 20.6.2012 11:09, Michal Kozusznik napsal(a): >> I suggest to use 1.14.0. >> Any newer version has another bug valid for postgresql 8.4: missing >> default values of function arguments) which may be dangerous if you >> work with this feature. >> >> with regards >> >>> Thanks. I'll use 1.14.2 until the next release. >> > >