pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Alter column varchar(n) via updating pg_attribute 2+ messages / 2 participants [nested] [flat]
* Alter column varchar(n) via updating pg_attribute @ 2011-09-01 22:41 Geoff Tolley <geoff.tolley@yougov.com> 0 siblings, 1 reply; 2+ messages in thread From: Geoff Tolley @ 2011-09-01 22:41 UTC (permalink / raw) To: 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 --------------- ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Alter column varchar(n) via updating pg_attribute @ 2011-09-02 04:34 Tom Lane <tgl@sss.pgh.pa.us> parent: Geoff Tolley <geoff.tolley@yougov.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2011-09-02 04:34 UTC (permalink / raw) To: Geoff Tolley <geoff.tolley@yougov.com>; +Cc: pgsql-admin Geoff Tolley <geoff.tolley@yougov.com> writes: > 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). I can't see why it wouldn't. The WAL/replication mechanism works at such a low level that it has no idea whether an update to pg_attribute originated in an official DDL command or a manual UPDATE of the catalog. I think you should be more worried about fat-fingering the update than whether it will be replicated correctly. But, of course, testing is always a good idea ;-) regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-09-02 04:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-09-01 22:41 Alter column varchar(n) via updating pg_attribute Geoff Tolley <geoff.tolley@yougov.com> 2011-09-02 04:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox