[HACKERS] Weird...but correct?

2004-07-25 Thread Christopher Kings-Lynne
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

Re: [HACKERS] Weird...but correct?

2004-07-25 Thread Christopher Kings-Lynne
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)---

Re: [HACKERS] Weird...but correct?

2004-07-26 Thread Tom Lane
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