| Lists: | Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2009-08-21 이후 PGSQL-BUGS 14:36 |
|---|
| From: | fabiofurlan <spdebian(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | When Drop Table or alter Table I need restart service Posgresql - 8.1 ????? |
| Date: | 2009-08-21 14:36:03 |
| Message-ID: | 25081017.post@talk.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2009-08-21 이후 PGSQL-BUGS 14:36 |
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.
--
View this message in context: http://www.nabble.com/When-Drop-Table-or-alter-Table-I-need-restart-service-Posgresql---8.1-------tp25081017p25081017.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| 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 16:45:33 |
| Message-ID: | 3073cc9b0908210945t6d55edb1jff1510b877c5b998@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Fri, Aug 21, 2009 at 9: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.
>
no, you don't have to. you have a specific problem of this kind?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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