Fwd: postgresql-autodoc - missinterprets "version"

Hi PostgreSQL developers!

Recently we got the bug report below. It seems that there is a special
treatment of columns named "version". Normally fields of primary key
indices are printed out unquoted, however, if the column is named
"version", the name is printed out in quotes.

This behaviour seems to confuse PostgreSQL autotoc.

Does this behaviour serve any purpose or it is an error?

Thanks and have a nice day!

Martin

----- Forwarded message from Bastian Blank <waldi(at)debian(dot)org> -----

Date: Sat, 29 May 2004 17:17:42 +0200
From: Bastian Blank <waldi(at)debian(dot)org>
To: submit(at)bugs(dot)debian(dot)org
Subject: postgresql-autodoc - missinterprets "version"
X-Spam-Status: No, hits=-7.0 required=4.0 tests=BAYES_01,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25

Package: postgresql-autodoc
Version: 1.22-2
Severity: normal

postgresql_autodoc missinterprets fields with name "version", as
postgresql sometimes reports version, sometimes "version".

| F-Key Name Type Description
| "version" UNIQUE#1
| id serial PRIMARY KEY
| package.version.id version integer NOT NULL
| package.binarypackage_name.id binarypackage_name integer UNIQUE#1 NOT NULL

Bastian

--
Military secrets are the most fleeting of all.
-- Spock, "The Enterprise Incident", stardate 5027.4

----- End forwarded message -----
----- Forwarded message from Tommaso Moroni <moronito(at)debian(dot)org> -----

Date: Mon, 31 May 2004 20:43:08 +0200
From: Tommaso Moroni <moronito(at)debian(dot)org>
To: 251595(at)bugs(dot)debian(dot)org
Subject: Re: Processed: reassigning bug #251595 to postgresql package
Mail-Followup-To: 251595(at)bugs(dot)debian(dot)org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2004_03_25

On Mon, May 31, 2004 at 06:09:58PM +0100, Oliver Elphick wrote:
> What SQL command produced these results?

Actually they are the postgresql-autodoc output. Here's what
I've tried:

test=> CREATE TABLE test (version smallint primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"
CREATE TABLE
test=> \d test
Tabella "public.test"
Colonna | Tipo | Modificatori
---------+----------+--------------
version | smallint | not null
Indici:
"test_pkey" chiave primaria, btree ("version")

The strange thing is the last line. I also tried with different
field types and got the same results. However if the field name isn't
"version" there are no problem at all.

I hope it helps.
--
Tommaso Moroni
moronito(at)debian(dot)org

----- End forwarded message -----

--
Martin Pitt Debian GNU/Linux Developer
martin(at)piware(dot)de mpitt(at)debian(dot)org
http://www.piware.de http://www.debian.org