Skip site navigation (1) Skip section navigation (2)

Re: Adding column comment to information_schema.columns

From: Jochem van Dieten <jochemd(at)gmail(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-02 17:50:08
Message-ID: f96a9b8304070210502c42da29@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, 02 Jul 2004 14:57:18 +0300, Hannu Krosing <hannu(at)tm(dot)ee> wrote:
> 
> IIRC we were recently told (in this thread) that the SQL standard tells
> to end local customisations with underscore, so it would be
> 'column_comment_'

I didn't write that (or at least, I didn't mean to write that :-). The
SQL standard tells that they will not use trailing underscores,
therefore *my* conclusion is that it is future proof (from a standards
perspective) if all PostgreSQL extensions use a trailing underscore.
Which also gives an indication to the user that it is a PostgreSQL
extension.

"NOTE 77 - It is the intention that no <key word> specified in ISO/IEC
9075 or revisions thereto shall end with an <underscore>."
ISO/IEC 9075-2:2003   5.4   Names and Identifiers

Jochem

In response to

Responses

pgsql-hackers by date

Next:From: Thomas SwanDate: 2004-07-02 18:37:46
Subject: Re: Nested Transactions, Abort All
Previous:From: Alvaro HerreraDate: 2004-07-02 17:24:00
Subject: Re: Subtle bug in clog.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group