X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8950856746 for ; Tue, 22 Mar 2005 18:06:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17036-09 for ; Tue, 22 Mar 2005 18:06:29 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id EFCC85673C for ; Tue, 22 Mar 2005 18:06:26 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 22 Mar 2005 12:06:23 -0600 Subject: Re: Adding field to a table currently being used From: Scott Marlowe To: Jada Case Cc: pgsql-admin@postgresql.org In-Reply-To: <001c01c52f06$5cc041a0$6e00a8c0@jada> References: <001c01c52f06$5cc041a0$6e00a8c0@jada> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1111514782.26897.1449.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 22 Mar 2005 12:06:23 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/348 X-Sequence-Number: 16846 On Tue, 2005-03-22 at 11:41, Jada Case wrote: > Hello, > > I need to know if I add a field to an existing table within a database > that is currently being accessed by many users, if it will effect it > or crash it? I have researced the archives and could not find an > answer, if there is documentation on this, will you point me in the > right direction? > It definitely won't crash the server, PostgreSQL is quite robust. Certain alter table actions may need to take out a short lived lock, but shouldn't normally cause another client to fail, unless that client is relying on a column that is being altered in some way that conflicts with that client.