Skip site navigation (1) Skip section navigation (2)

Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: fabiofurlan <spdebian(at)yahoo(dot)com(dot)br>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Date: 2009-08-23 00:41:23
Message-ID: 3073cc9b0908221741x45441dd7oa1a7806042f28e8c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, Aug 21, 2009 at 2:58 PM, Robert Haas<robertmhaas(at)gmail(dot)com> wrote:
>
> Maybe you are doing this inside a transaction someplace?  If so, it
> won't be visible to other transactions until you commit.
>

but then, if he simply restart the service the transaction will rollback

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

pgsql-bugs by date

Next:From: Greg StarkDate: 2009-08-23 01:40:19
Subject: Re: 8.4.0 data loss / HOT-related bug
Previous:From: hubert depesz lubaczewskiDate: 2009-08-22 17:52:41
Subject: Re: BUG #5004: pg_freespacemap make a SegFault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group