Обсуждение: 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

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

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

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.
>>
>
>