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 <[EMAIL PROTECTED]> -----
Date: Sat, 29 May 2004 17:17:42 +0200
From: Bastian Blank <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]> -----
Date: Mon, 31 May 2004 20:43:08 +0200
From: Tommaso Moroni <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Processed: reassigning bug #251595 to postgresql package
Mail-Followup-To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
----- End forwarded message -----
--
Martin Pitt Debian GNU/Linux Developer
[EMAIL PROTECTED] [EMAIL PROTECTED]
http://www.piware.de http://www.debian.org
signature.asc
Description: Digital signature
