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

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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: fabiofurlan <spdebian(at)yahoo(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Date: 2009-08-21 19:58:37
Message-ID: 603c8f070908211258u128c639fh1775b143448508b5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, Aug 21, 2009 at 10:36 AM, fabiofurlan<spdebian(at)yahoo(dot)com(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Radoslaw ZielinskiDate: 2009-08-22 16:27:09
Subject: Re: 8.4.0 data loss / HOT-related bug
Previous:From: Robert HaasDate: 2009-08-21 19:56:08
Subject: Re: Regarding permissions

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