Author: dpage
Date: 2005-05-20 10:29:33 +0100 (Fri, 20 May 2005)
New Revision: 4225

Modified:
   trunk/pgadmin3/src/schema/pgDomain.cpp
Log:
Use pg_get_constraintdef(pg_constraint.oid) to get domain contraint details.

Modified: trunk/pgadmin3/src/schema/pgDomain.cpp
===================================================================
--- trunk/pgadmin3/src/schema/pgDomain.cpp      2005-05-20 08:45:58 UTC (rev 
4224)
+++ trunk/pgadmin3/src/schema/pgDomain.cpp      2005-05-20 09:29:33 UTC (rev 
4225)
@@ -70,7 +70,7 @@
         if (GetConnection()->BackendMinimumVersion(7, 4))
         {
             pgSet *set=ExecuteSet(
-                wxT("SELECT conname, consrc FROM pg_constraint WHERE 
contypid=") + GetOidStr());
+                wxT("SELECT conname, pg_get_constraintdef(oid) AS consrc FROM 
pg_constraint WHERE contypid=") + GetOidStr());
             if (set)
             {
                 while (!set->Eof())


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to