Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C7A0D13364DE for ; Fri, 11 Mar 2011 11:23:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 38768-04 for ; Fri, 11 Mar 2011 15:23:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (unknown [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 36911133616B for ; Fri, 11 Mar 2011 11:23:45 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 55EF7348046; Fri, 11 Mar 2011 07:23:27 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id P0LTDA-2k5aU; Fri, 11 Mar 2011 07:23:25 -0800 (PST) Received: from perhan.alvh.no-ip.org (unknown [190.95.20.220]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 1A5CF348022; Fri, 11 Mar 2011 07:23:25 -0800 (PST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 90C156E58B; Fri, 11 Mar 2011 12:23:22 -0300 (CLST) Content-Type: text/plain; charset=UTF-8 Cc: Kevin Grittner , Thom Brown , PostgreSQL-development Subject: Re: Couple document fixes From: Alvaro Herrera To: Bruce Momjian In-reply-to: <201103111113.p2BBDKX04227@momjian.us> References: <201103111113.p2BBDKX04227@momjian.us> Date: Fri, 11 Mar 2011 12:23:22 -0300 Message-Id: <1299856725-sup-5827@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201103/782 X-Sequence-Number: 184032 Removing CC to pg-docs so that Robert reads it. Excerpts from Bruce Momjian's message of vie mar 11 08:13:20 -0300 2011: > Kevin Grittner wrote: > > relpersistence should be "char", not char. > > Oddly enough, there is a difference. > > I am unsure on that one. We have many 'char' mentions in catalog.sgml, > and I don't see any of them shown as '"char"'. (Wow, we should have > just called this type char1, but I think that name came from Berkeley!) > The big problem is that the pg_type name is really "char" _without_ > quotes. One idea is to rename the type to something else. We could keep "char" as an alias for backwards compatibility, but use the new name in system catalogs, and document it as the main name of the type. Discussed the idea a bit on IM with Bruce, but couldn't find any really good alternative. Idea floated so far: * byte (seems pretty decent to me) * octet (though maybe people would expect it'd output as a number) * char1 (looks ugly, but then we have int4 and so on) * achar (this one is just plain weird) None seems great. Thoughts? -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support