It's bizarre how you can comment on columns in composite types!
CREATE TYPE test (a int4, b int4);
COMMENT ON COLUMN test.a IS 'A column';
Seems harmless, but should we allow it?
Chris
---(end of broadcast)---
TIP 6: Have you searched our list archive
CREATE TYPE test (a int4, b int4);
COMMENT ON COLUMN test.a IS 'A column';
Seems harmless, but should we allow it?
Actually, currently it's bad because such comments will not be dumped by
pg_dump. Shall I fix pg_dump?
Chris
---(end of broadcast)---
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> It's bizarre how you can comment on columns in composite types!
> CREATE TYPE test (a int4, b int4);
> COMMENT ON COLUMN test.a IS 'A column';
And not only that, but:
regression=# \d+ test
Composite type "public.test"
Column | Type | Desc