Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin III commit: Fix constraints handling on the table properties di

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: pgAdmin III commit: Fix constraints handling on the table properties di
Date: 2011-12-19 11:58:53
Message-ID: 28ce3f66-f03b-4a5e-bc8a-568cd29cf252@p20g2000vbm.googlegroups.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Dec 19, 12:42 pm, Erwin Brandstetter <brsaw(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> On Dec 10, 11:46 am, guilla(dot)(dot)(dot)(at)lelarge(dot)info (Guillaume Lelarge) wrote:
>
>
>
>
>
>
>
>
>
> > Fix constraints handling on the table properties dialog
>
> > The wxListCtrl control doesn't handle strings or more than 512 characters on
> > Windows. So we need to put the definition of constraints in a wxArrayString so
> > that we won't have issues on the size of the constraint's definition.
>
> > Report from Vjacheslav Vjacheslav.
> > Some help from Julius Tuskenis.
>
> > Branch
> > ------
> > REL-1_14_0_PATCHES
>
> > Details
> > -------http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=19a76d...
>
> > Modified Files
> > --------------
> > CHANGELOG                      |    2 ++
> > pgadmin/dlg/dlgTable.cpp       |   16 ++++++++++++++--
> > pgadmin/include/dlg/dlgTable.h |    2 +-
> > 3 files changed, 17 insertions(+), 3 deletions(-)
>
> > --
> > Sent via pgadmin-hackers mailing list (pgadmin-hack(dot)(dot)(dot)(at)postgresql(dot)org)
> > To make changes to your subscription:http://www.postgresql.org/mailpref/pgadmin-hackers
>
> This is quite a crippling bug. I ran into this after recreating a
> table in PostgreSQL 8.4 by using the reverse engineered SQL in the SQL
> pane. I did not realize the nonsensical statements further down at
> first. Like:
>
> CREATE CONSTRAINT TRIGGER "RI_ConstraintTrigger_142372"
>   AFTER INSERT
>   ON wuchtel.bet
>   FOR EACH ROW
>   EXECUTE PROCEDURE "RI_FKey_check_ins"();
>
> The DDL commands worked - the table was created. But later when I
> tried to insert data I ran into strange errors:
>    No »pg_constraint«-entry for trigger »RI_ConstraintTrigger_142372«
> for table »bet2«
>
> I am afraid this will make quite a few users trip. I would very much
> welcome an early release of 1.14.3.
>
> Regards
> Erwin

Oops.
s/1.14.3/1.14.2

In response to

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-12-19 13:07:44
Subject: Re: Re: pgAdmin III commit: Fix constraints handling on the table properties di
Previous:From: Erwin BrandstetterDate: 2011-12-19 11:42:47
Subject: Re: pgAdmin III commit: Fix constraints handling on the table properties di

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group