COMMENT ON mega patch

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: COMMENT ON mega patch
Date: 2003-11-19 06:32:23
Message-ID: 3FBB0E77.3010305@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

This patch does the following:

1. Comment on 5 new objects:

COMMENT ON CONVERSION my_conv IS 'Conversion to Unicode';
COMMENT ON LANGUAGE plpython IS 'Python support for stored procedures';
COMMENT ON OPERATOR CLASS int4ops USING btree IS '4 byte integer
operators for btrees';
COMMENT ON LARGE OBJECT 346344 IS 'Planning document';
COMMENT ON CAST (text AS int4) IS 'Allow casts from text to int4';

2. Dump conversions with pg_dump

3. Dump comments on conversions, languages, opclasses and casts with pg_dump

4. Upgrade psql's lob interface to use COMMENT ON instead of hacky insert.

5. Make large object comments get automatically removed when the object
is lo_unlink'd, so clients don't need any special code.

6. Documentation updates for (1)

7. Regression tests for commenting on all objects (currently COMMENT ON
is strangely absent from the regression tests, as this shows:
http://www.alcove.com.au/pgregress/commands/index.html )

Chris

Attachment Content-Type Size
comment.txt.gz application/x-gzip 12.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2003-11-19 19:23:51 Add GUC setting to make created tables default to WITHOUT
Previous Message Christopher Kings-Lynne 2003-11-19 05:06:08 Re: Make pg_dump dump conversions