Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-20 Thread Uday Pandian
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 wrote: > Ahh I'm stupid. > 1.14.2 is OK - just checked. > Sorry for making mess. > > Dne 20.6.2012 11:09, Michal

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-20 Thread Michal Kozusznik
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 f

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-20 Thread Michal Kozusznik
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.

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-19 Thread Michael Shapiro
Thanks. I'll use 1.14.2 until the next release. On Tue, Jun 19, 2012 at 9:06 AM, Guillaume Lelarge wrote: > On Tue, 19 Jun 2012 09:00:16 -0500, Michael Shapiro > 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

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-19 Thread Guillaume Lelarge
On Tue, 19 Jun 2012 09:00:16 -0500, Michael Shapiro 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 ht

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-19 Thread Guillaume Lelarge
On Mon, 18 Jun 2012 17:02:38 +0200, Guillaume Lelarge 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 w

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Guillaume Lelarge
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

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Michael Shapiro
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 wrote: > We are running > > PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) > 4.1.2 20080704 (Red Ha

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Michael Shapiro
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-bit On Mon, Jun 18, 2012 at 4:23 AM, Guillaume Lelarge wrote: > On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote: > > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Guillaume Lelarge
On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote: > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik > 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 re

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Dave Page
On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik 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 ind

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Michal Kozusznik
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 t

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Dave Page
On Mon, Jun 18, 2012 at 9:31 AM, Michael Shapiro 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 r

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Michael Shapiro
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 On Mon, Jun 18, 2012 at 3:25 AM, Guillaume Lelarg

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-18 Thread Guillaume Lelarge
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

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-08 Thread Michal Kozusznik
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/pg

Re: [pgadmin-support] RI_ConstraintTrigger

2012-06-07 Thread Guillaume Lelarge
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 si

[pgadmin-support] RI_ConstraintTrigger

2012-06-06 Thread Michal Kozusznik
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