Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 616CC9F9E8F for ; Tue, 14 Aug 2007 22:10:23 -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 98396-02 for ; Tue, 14 Aug 2007 22:10:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from copgpuniv.digitalglobe.com (ew-fw-out.digitalglobe.com [205.166.175.2]) by postgresql.org (Postfix) with ESMTP id 592549F9E8D for ; Tue, 14 Aug 2007 22:09:49 -0300 (ADT) Received: from copgpuniv.digitalglobe.com (localhost.localdomain [127.0.0.1]) by copgpuniv.digitalglobe.com (PGP Universal) with ESMTP id D9F6E2A03A2 for ; Tue, 14 Aug 2007 19:09:46 -0600 (MDT) Received: from comailgate.digitalglobe.com ([10.10.42.50]) by copgpuniv.digitalglobe.com (PGP Universal service); Tue, 14 Aug 2007 19:09:46 -0600 X-PGP-Universal: processed; by copgpuniv.digitalglobe.com on Tue, 14 Aug 2007 19:09:46 -0600 Received: from COMAIL01.digitalglobe.com ([10.10.42.60]) by comailgate.digitalglobe.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 14 Aug 2007 19:09:46 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7DED8.F8118D95" Subject: NAMEDATALEN change Date: Tue, 14 Aug 2007 19:09:45 -0600 Message-ID: <8B319E5A30FF4A48BE7EEAAF609DB233011B04F5@COMAIL01.digitalglobe.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: NAMEDATALEN change Thread-Index: Acfe2PgHtsMlZP0TS56tv6m9AuO+8Q== From: "Gregory Williamson" To: X-OriginalArrivalTime: 15 Aug 2007 01:09:46.0244 (UTC) FILETIME=[F83DA440:01C7DED8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/169 X-Sequence-Number: 26500 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7DED8.F8118D95 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We need to change the maximum length of table/column name lengths, and = it looks as if changing NAMEDATALEN in src/include/postgres_ext.h and = recompiling postgres. 2 questions: a) Do I need to dump the database and reload ? (my guess is yes but only = a guess ...) b) any caveats or warnings about this ? TIA, Greg Williamson Senior DBA GlobeXplorer LLC, a DigitalGlobe company Confidentiality Notice: This e-mail message, including any attachments, = is for the sole use of the intended recipient(s) and may contain = confidential and privileged information and must be protected in = accordance with those provisions. Any unauthorized review, use, = disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply e-mail and destroy all = copies of the original message. (My corporate masters made me say this.) ------_=_NextPart_001_01C7DED8.F8118D95 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable NAMEDATALEN change

We need to change the maximum length of table/column = name lengths, and it looks as if changing NAMEDATALEN in = src/include/postgres_ext.h and recompiling postgres.

2 questions:

a) Do I need to dump the database and reload ? (my guess is yes but only = a guess ...)

b) any caveats or warnings about this ?

TIA,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, = is for the sole use of the intended recipient(s) and may contain = confidential and privileged information and must be protected in = accordance with those provisions. Any unauthorized review, use, = disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply e-mail and destroy all = copies of the original message.

(My corporate masters made me say this.)

------_=_NextPart_001_01C7DED8.F8118D95--