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