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

Constraint Bug

From: "Trevor McGing" <tmcging(at)strategyanalytics(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Constraint Bug
Date: 2003-10-29 16:10:07
Message-ID: CB097A735666A94680966883E7DBC919351C5E@mail.strategyanalytics.com (view raw or flat)
Thread:
Lists: pgadmin-support
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.
 
I hope that this is of help to you.
 
regards
Trevor
 
 
 

Responses

pgadmin-support by date

Next:From: timothy.r.morleyDate: 2003-10-29 16:10:56
Subject: Connnection to SSL enabled server
Previous:From: Christopher Kings-LynneDate: 2003-10-29 01:40:22
Subject: Re: DBMigration-Wizard & Access 2002

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