Alter column varchar(n) via updating pg_attribute

From: Geoff Tolley <geoff(dot)tolley(at)yougov(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Alter column varchar(n) via updating pg_attribute
Date: 2011-09-01 22:41:48
Message-ID: 4E600A2C.9030307@yougov.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

---------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-09-02 04:34:04 Re: Alter column varchar(n) via updating pg_attribute
Previous Message Marc Cousin 2011-09-01 14:10:52 pg_restore -j mixed and missing lines of output