pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAdding 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