Reference by output in : \d - Mailing list pgsql-patches

Hi,
 
Refering to this request http://momjian.us/mhonarc/patches_hold/msg00022.html
I have created a patch. The output doesn't exaclty match with what is stated here
http://momjian.us/mhonarc/patches_hold/msg00023.html.
However, it does tell the required details in a similar format.
 
Comments?
 
 
Thanks,
Kenneth

osdb_pgarch=# \d htest
           Table "public.htest"
    Column    |     Type      | Modifiers
--------------+---------------+-----------
 new_id       | integer       | not null
 test_name    | character(20) |
 test_cust_id | integer       |
Indexes:
    "htest_pkey" PRIMARY KEY,  btree (new_id)
Foreign-key constraints:
    "htest_test_cust_id_fkey" FOREIGN KEY (test_cust_id) REFERENCES customers(customer_id)
Refrenced by :
  "htest_child_ctest_cust_id_fkey" IN public.htest_child(ctest_cust_id) REFERENCES htest(new_id)
  "htest_child1_ctest_cust_id_fkey" IN public.htest_child1(ctest_cust_id) REFERENCES htest(new_id)
 
 
diff describe.c_orig describe.c
1109c1109,1110
<                                  *result6 = NULL;
---
>                                  *result6 = NULL,
>                                  *result7 = NULL;
1114a1116
>                                         refof_count = 0,
1247,1248c1249,1265
<               footers = pg_malloc_zero((index_count + check_count + rule_count + trigger_count + foreignkey_count + inherit
s_count + 7 + 1)
<                                                                * sizeof(*footers));
---
>               /* reference_by count */
>
>                 printfPQExpBuffer(&buf,"SELECT c.conname,n.nspname,p2.relname,pg_catalog.pg_get_constraintdef(c.oid, true)\
n"
>                                       "FROM pg_catalog.pg_class p, pg_catalog.pg_constraint c,  pg_catalog.pg_class p2 \n"
>                                       ",pg_catalog.pg_namespace n WHERE p.oid = '%s' AND c.confrelid = '%s'\n"
>                                       "AND c.conrelid = p2.oid AND n.oid =p2.relnamespace", oid,oid);
>
>                 result7 = PSQLexec(buf.data, false);
>                 if (!result7)
>                         goto error_return;
>                 else
>                         refof_count = PQntuples(result7);
>
>
>                 footers = pg_malloc_zero((index_count + check_count + rule_count + trigger_count + foreignkey_count + inher
its_count + refof_count +  7 + 1) * sizeof(*footers));
>
>
1483a1501,1526
>               /* print reference count details */
>                 if (refof_count > 0)
>                 {
>                         printfPQExpBuffer(&buf, _("Refrenced by :"));
>                         footers[count_footers++] = pg_strdup(buf.data);
>                         for (i = 0; i < refof_count; i++)
>                         {
>                                 const char *refbydef;
>                                 const char *usingpos;
>                                 printfPQExpBuffer(&buf, _("  \"%s\" IN %s.%s"),
>                                                                    PQgetvalue(result7,i,0),
>                                                                  PQgetvalue(result7,i,1),
>                                                                  PQgetvalue(result7,i,2));
>
>                                 /* Everything after "FOREIGN KEY " is echoed verbatim */
>                                 refbydef = PQgetvalue(result7, i, 3);
>                                 usingpos = strstr(refbydef, "FOREIGN KEY ");
>                                 if (usingpos)
>                                         refbydef = usingpos + 12;
>                                 appendPQExpBuffer(&buf, "%s",refbydef);
>
>                                 footers[count_footers++] = pg_strdup(buf.data);
>                         }
>                  }
>
 

---

Live the life in style with MSN Lifestyle. Check out! Try it now!