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.=20
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@debian.org> -----
Date: Sat, 29 May 2004 17:17:42 +0200
From: Bastian Blank <waldi@debian.org>
To: submit@bugs.debian.org
Subject: postgresql-autodoc - missinterprets "version"
X-Spam-Status: No, hits=3D-7.0 required=3D4.0 tests=3DBAYES_01,HAS_PACKAGE=
=20
autolearn=3Dno version=3D2.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 NO=
T NULL
Bastian
--=20
Military secrets are the most fleeting of all.
-- Spock, "The Enterprise Incident", stardate 5027.4
----- End forwarded message -----
----- Forwarded message from Tommaso Moroni <moronito@debian.org> -----
Date: Mon, 31 May 2004 20:43:08 +0200
From: Tommaso Moroni <moronito@debian.org>
To: 251595@bugs.debian.org
Subject: Re: Processed: reassigning bug #251595 to postgresql package
Mail-Followup-To: 251595@bugs.debian.org
X-Spam-Status: No, hits=3D-3.0 required=3D4.0 tests=3DBAYES_00 autolearn=3D=
no=20
version=3D2.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=3D> CREATE TABLE test (version smallint primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" =
for table "test"
CREATE TABLE
test=3D> \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=20
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.
--=20
Tommaso Moroni
moronito@debian.org
----- End forwarded message -----
--=20
Martin Pitt Debian GNU/Linux Developer
martin@piware.de mpitt@debian.org
http://www.piware.de http://www.debian.org
