Re: Feature Request: inline comments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CaT <cat(at)zip(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature Request: inline comments
Date: 2007-11-07 23:32:53
Message-ID: 11720.1194478373@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

CaT <cat(at)zip(dot)com(dot)au> writes:
> It is a pretty obvious suggestion I bet was made many, many times
> before, but it would be very useful if you could create comments while
> creating the objects themselves, like

> CREATE TABLE FOO (
> ID INTEGER NOT NULL PRIMARY KEY COMMENT 'The ID',
> VALUE VARCHAR(10) COMMENT 'The value',
> ) COMMENT 'The table';

This seems like a fairly bad idea to me, because it converts your table
definitions into proprietary syntax. Heaven help you trying to load the
above into any other database. With a separate COMMENT ON command, at
least you have a fighting chance of ignoring the errors and pressing on.

> Perhaps this is a small enough add to make it into 8.3?

Feature freeze was six months ago, and no this wouldn't be a "small
add" even if it was the best idea since sliced bread.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Smet 2007-11-07 23:32:55 Re: Estimation problem with a LIKE clause containing a /
Previous Message Tom Lane 2007-11-07 23:24:47 Re: Throw error and ErrorContext question.