--- src/schema/pgCheck.cpp.orig	Fri Sep 12 10:33:22 2003
+++ src/schema/pgCheck.cpp	Fri Sep 12 11:30:39 2003
@@ -97,11 +97,12 @@
 {
     pgCheck *check=0;
     pgSet *checks= collection->GetDatabase()->ExecuteSet(
-        wxT("SELECT c.oid, conname, condeferrable, condeferred, relname, nspname,\n")
+        wxT("SELECT c.oid, conname, condeferrable, condeferred, relname, nspname, description,\n")
         wxT("       pg_get_expr(conbin, conrelid") + collection->GetDatabase()->GetPrettyOption() + wxT(") as consrc\n")
         wxT("  FROM pg_constraint c\n")
         wxT("  JOIN pg_class cl ON cl.oid=conrelid\n")
         wxT("  JOIN pg_namespace nl ON nl.oid=relnamespace\n")
+        wxT("  LEFT OUTER JOIN pg_description des ON des.objoid=c.oid\n")
         wxT(" WHERE contype = 'c' AND conrelid =  ") + NumToStr(collection->GetOid())
         + restriction + wxT("::oid\n")
         wxT(" ORDER BY conname"));
@@ -119,6 +120,7 @@
             check->iSetFkSchema(checks->GetVal(wxT("nspname")));
             check->iSetDeferrable(checks->GetBool(wxT("condeferrable")));
             check->iSetDeferred(checks->GetBool(wxT("condeferred")));
+            check->iSetComment(checks->GetVal(wxT("description")));
 
             if (browser)
             {
--- src/ui/dlgCheck.cpp.orig	Fri Sep 12 10:26:16 2003
+++ src/ui/dlgCheck.cpp	Fri Sep 12 10:33:03 2003
@@ -101,6 +101,8 @@
         txtWhere->SetValue(check->GetDefinition());
         txtWhere->Disable();
 
+        txtComment->SetValue(check->GetComment());
+
         chkDeferrable->SetValue(check->GetDeferrable());
         chkDeferred->SetValue(check->GetDeferred());
         chkDeferrable->Disable();