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: (view raw, whole thread or download thread mbox)
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!


----- 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
|              version              integer  NOT NULL
|   binarypackage_name   integer  UNIQUE#1 NOT NULL


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 

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"
test=> \d test
       Tabella "public.test"
 Colonna |   Tipo   | Modificatori
 version | smallint | not null
    "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

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

Martin Pitt                 Debian GNU/Linux Developer
martin(at)piware(dot)de                      mpitt(at)debian(dot)org   


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-2017 The PostgreSQL Global Development Group