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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly