| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | shared description table. |
| Date: | 2005-12-14 21:58:48 |
| Message-ID: | Pine.BSO.4.61.0512141653220.32015@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
I've created a new shared catalog table pg_shdescription to store comments
on cluster global objects like databases, tablespaces, and roles.
It touches a lot of places, but not much in the way of big changes. The
only design decision I made was to duplicate the query and manipulation
functions rather than to try and have them handle both shared and local
comments. I believe this is simpler for the code and not an issue for
callers because they know what type of object they are dealing with. This
has resulted in a shobj_description function analagous to obj_description
and backend functions [Create/Delete]SharedComments mirroring the existing
[Create/Delete]Comments functions.
pg_shdescription.h goes into src/include/catalog/
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| shared-description.patch | text/plain | 53.4 KB |
| pg_shdescription.h | text/plain | 2.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Girard | 2005-12-15 20:56:27 | Solaris cc compiler on amd: PostgreSQL does not have native spinlock support on this platform |
| Previous Message | Tom Lane | 2005-12-14 17:13:50 | Re: TODO item: list prepared queries |