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

Fwd: postgresql-autodoc - missinterprets "version"

From: Martin Pitt <martin(at)piware(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Fwd: postgresql-autodoc - missinterprets "version"
Date: 2004-07-08 13:42:34
Message-ID: 20040708134230.GA16556@donald.intranet.fbn-dd.de (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2004-07-08 14:10:22
Subject: Re: Fwd: postgresql-autodoc - missinterprets "version"
Previous:From: Martin PittDate: 2004-07-08 12:54:30
Subject: Re: Fwd: Bug#253295: postgresql: VACUUM FULL produce warnings

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