Please find attached three files, 2 pg_dump files from both posgres versions, and a schema genorated by pg Admin 2, i could not find away to do this in version 3. The schema was created before the migration, I tried to produce one after, but pgAdmin 2 had problems with postgres 7.3.
I get the same issue, pgAdmin 2 shows the constrants, and pgAdmin 3 does not.
If I create a constraint with pgAdmin 3, pgAdmin 2 reflects that change.
Hope these files help you.
OK Trevor,
the 7.2 dump works for me. It uses constraint triggers, as I suspected. pgAdmin3 suppresses constraint triggers, because they're working behind the scene and are not intended to be modified by users (for 7.3 and up).
When I run the script against 7.4, the script succeeds, and no constraint is shown because there is no pg_constraint entry. There's the script contrib/adddepend, which adds the missing rows.
I updated the FAQs.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
