pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Adding field to a table currently being used
2+ messages / 2 participants
[nested] [flat]

* Adding field to a table currently being used
@ 2005-03-22 17:41 Jada Case <jadac@mccright.com>
  2005-03-22 18:06 ` Re: Adding field to a table currently being used Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Jada Case @ 2005-03-22 17:41 UTC (permalink / raw)
  To: pgsql-admin

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
 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Adding field to a table currently being used
  2005-03-22 17:41 Adding field to a table currently being used Jada Case <jadac@mccright.com>
@ 2005-03-22 18:06 ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2005-03-22 18:06 UTC (permalink / raw)
  To: Jada Case <jadac@mccright.com>; +Cc: pgsql-admin

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-22 18:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-22 17:41 Adding field to a table currently being used Jada Case <jadac@mccright.com>
2005-03-22 18:06 ` Scott Marlowe <smarlowe@g2switchworks.com>

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