Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0A41AB5DCAE for ; Thu, 1 Sep 2011 20:13:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 95460-01 for ; Thu, 1 Sep 2011 23:13:28 +0000 (UTC) X-Greylist: delayed 00:15:01.676392 by SQLgrey-1.7.6 Received: from ch1outboundpool.messaging.microsoft.com (ch1ehsobe006.messaging.microsoft.com [216.32.181.186]) by mail.postgresql.org (Postfix) with ESMTP id D9A61B5DCB7 for ; Thu, 1 Sep 2011 20:13:27 -0300 (ADT) Received: from mail2-ch1-R.bigfish.com (216.32.181.168) by CH1EHSOBE011.bigfish.com (10.43.70.61) with Microsoft SMTP Server id 14.1.225.22; Thu, 1 Sep 2011 22:42:16 +0000 Received: from mail2-ch1 (localhost.localdomain [127.0.0.1]) by mail2-ch1-R.bigfish.com (Postfix) with ESMTP id 0053B19B82ED for ; Thu, 1 Sep 2011 22:42:17 +0000 (UTC) X-SpamScore: -4 X-BigFish: VPS-4(zz4015Lzz1202hzz8275dhz2dh2a8h668h839h63h) X-Spam-TCS-SCL: 2:0 X-Forefront-Antispam-Report: CIP:213.52.133.228; KIP:(null); UIP:(null); IPVD:NLI; H:smtp.yougov.com; RD:smtp.yougov.com; EFVD:NLI Received: from mail2-ch1 (localhost.localdomain [127.0.0.1]) by mail2-ch1 (MessageSwitch) id 1314916936920639_16829; Thu, 1 Sep 2011 22:42:16 +0000 (UTC) Received: from CH1EHSMHS007.bigfish.com (snatpool1.int.messaging.microsoft.com [10.43.68.243]) by mail2-ch1.bigfish.com (Postfix) with ESMTP id D47C5BF804F for ; Thu, 1 Sep 2011 22:42:16 +0000 (UTC) Received: from smtp.yougov.com (213.52.133.228) by CH1EHSMHS007.bigfish.com (10.43.70.7) with Microsoft SMTP Server (TLS) id 14.1.225.22; Thu, 1 Sep 2011 22:42:16 +0000 Received: from [192.168.1.121] (70.92.147.99) by smtp.yougov.com (10.32.8.3) with Microsoft SMTP Server (TLS) id 8.3.137.0; Thu, 1 Sep 2011 23:42:14 +0100 Message-ID: <4E600A2C.9030307@yougov.com> Date: Thu, 1 Sep 2011 17:41:48 -0500 From: Geoff Tolley User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.20) Gecko/20110805 Thunderbird/3.1.12 MIME-Version: 1.0 To: Subject: Alter column varchar(n) via updating pg_attribute Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-OriginatorOrg: yougov.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/8 X-Sequence-Number: 38245 The last time this was asked about (http://archives.postgresql.org/pgsql-admin/2010-02/msg00189.php), 9.0 was still alpha. Is there any reason to suspect that direct pg_attribute manipulation to expand a varchar(n) column might not play nice with streaming replication/hot standby? (Naturally I'm also in the process of testing). Thanks, Geoff ---------------