From jadac@mccright.com Tue Mar 22 17:42:14 2005 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 2004B56A24 for ; Tue, 22 Mar 2005 17:42:14 +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 10130-06 for ; Tue, 22 Mar 2005 17:41:27 +0000 (GMT) Received: from mail2.smartechcorp.net (mail2.smartechcorp.net [64.203.98.242]) by svr1.postgresql.org (Postfix) with ESMTP id 02B8A52A4F for ; Tue, 22 Mar 2005 17:41:26 +0000 (GMT) Received: from jada (adsl-214-219-11.cha.bellsouth.net [68.214.219.11]) by mail2.smartechcorp.net (Postfix) with ESMTP id 9D368B572 for ; Tue, 22 Mar 2005 12:41:25 -0500 (EST) From: "Jada Case" To: Subject: Adding field to a table currently being used Date: Tue, 22 Mar 2005 12:41:22 -0500 Message-ID: <001c01c52f06$5cc041a0$6e00a8c0@jada> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001D_01C52EDC.73EA39A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/347 X-Sequence-Number: 16845 This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C52EDC.73EA39A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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? Thank you, Jada ------=_NextPart_000_001D_01C52EDC.73EA39A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Hello,
 
I need = to know if I=20 add a field to an existing table within a database that is currently = being=20 accessed by many users, if it will effect it or crash it?  I have = researced=20 the archives and could not find an answer, if there is documentation on = this,=20 will you point me in the right direction?
 
Thank=20 you,
 
Jada
 
------=_NextPart_000_001D_01C52EDC.73EA39A0-- From smarlowe@g2switchworks.com Tue Mar 22 18:06:34 2005 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.