Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 615E29FA1BB for ; Tue, 17 Apr 2007 14:03:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 18585-02 for ; Tue, 17 Apr 2007 14:03:00 -0300 (ADT) X-Greylist: delayed 00:32:58.39381 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E358E9FA3A7 for ; Tue, 17 Apr 2007 14:03:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.network-theory.co.uk (network-theory.com [66.199.228.187]) by svr4.postgresql.org (Postfix) with ESMTP id 434FF5AF893 for ; Tue, 17 Apr 2007 16:30:02 +0000 (GMT) Date: Tue, 17 Apr 2007 17:29:59 +0100 Message-ID: <87slazm0ag.wl%bjg@network-theory.co.uk> From: Brian Gough To: pgsql-docs@postgresql.org Subject: patch for overflowing tables User-Agent: Wanderlust/2.14.0 (Africa) Emacs/21.3 Mule/5.0 (SAKAKI) MIME-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII X-Message-Mac: edb5ea3b7f6e9fdf68f181489c0d25ed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200704/16 X-Sequence-Number: 4212 Hello, The cols attribute in a couple of tables does not match the actual number of entries in the tables, causing them to overflow the edge of the page. The patch below fixes the problem -- I didn't find any other cases apart from these two. -- best regards, Brian Gough Index: doc/src/sgml/datatype.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v retrieving revision 1.195 diff -u -8 -r1.195 datatype.sgml --- doc/src/sgml/datatype.sgml 6 Apr 2007 19:22:38 -0000 1.195 +++ doc/src/sgml/datatype.sgml 17 Apr 2007 16:02:04 -0000 @@ -1933,17 +1933,17 @@ (In particular, now and related strings are converted to a specific time value as soon as they are read.) All of these values need to be written in single quotes when used as constants in SQL commands. Special Date/Time Inputs - + Input String Valid Types Description Index: doc/src/sgml/ecpg.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v retrieving revision 1.82 diff -u -8 -r1.82 ecpg.sgml --- doc/src/sgml/ecpg.sgml 16 Feb 2007 03:56:45 -0000 1.82 +++ doc/src/sgml/ecpg.sgml 17 Apr 2007 16:02:07 -0000 @@ -1480,17 +1480,17 @@ the month and dd to indicate the position of the day. The following table indicates a few possible formats. This will give you an idea of how to use this function.
Valid input formats for <function>rdefmtdate</function> - + fmt str result