Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ????? - Mailing list pgsql-bugs

From Robert Haas
Subject Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Date
Msg-id 603c8f070908211258u128c639fh1775b143448508b5@mail.gmail.com
Whole thread Raw
In response to When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????  (fabiofurlan <spdebian@yahoo.com.br>)
Responses Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-bugs
On Fri, Aug 21, 2009 at 10:36 AM, fabiofurlan<spdebian@yahoo.com.br> wrote:
>
> Hi.
>
> I do not any idea.
>
> When i drop table or alter table, i need restart service postgresql 8.1,
> because is impossible new connect or
> because the changes are not visible.
>
> Gnu Linux Debian 4.0
> PostgreSQL 8.1
>
>
> Thanks a lot.

Maybe you are doing this inside a transaction someplace?  If so, it
won't be visible to other transactions until you commit.

...Robert

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Regarding permissions
Next
From: Radoslaw Zielinski
Date:
Subject: Re: 8.4.0 data loss / HOT-related bug