Re: Constraint Bug

For the record, I have also experienced this exact problem when upgrading from PGSQL 7.2 to PGSQL 7.3 (and pgAdminII to pgAdminIII at the same time).

My FK constraints are still there, but are totally invisible in pgAdminIII.

Andreas Pflug <pgadmin(at)pse-consulting(dot)de> wrote :

> Trevor McGing wrote:
>
> > Hi,
> >
> > Platform Windows XP
> >
> > Distribution you used (Binary pgAdmin 3 )
> >
> > I have been using pgAdmin 2 under dbexperts postgresql 7.2 for
> > windows. Where I created a database.
> >
> > I have just upgraded to dbexperts Postgresql 7.3.4 for windows,
> > migrated the database from one version to the other and I am now using
> > pgAdmin 3. Everything seamed to be OK until I looked at the FK
> > constraints. At first I thought it was a problem with the migration,
> > so I re-created the Contraints using pgAdmin 3, which there was no
> > problem in doing. However I then went back to pg Admin 2 to see if it
> > would show the contraints as a check, it compained about duplicate
> > contriaints being present. After removing the Constraints that I had
> > just added in pgAdmin 3, pgAdmin 2 allowed me to see the contraints
> > without any errors.
> >
> > To sum up pgAdmin 3 does not seam to be displaying the FK contraint
> > information at all, either in the dialog boxes or the SQL code, and
> > does not complain if you re-add a constraint that is already there.
> >
> This problem is not known. Can you supply a small ddl script of some
> tables and FKs so we can have a look at it?
> The problem might result from an old style FK representation (actually
> no constraint, but a trigger), which should be converted to new style
> (I'm no expert for
>
> Regards,
> Andreas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--Matt