Jeff, Bryan, Teodor:
thank you all so much!!!
one related/furthur question:
>0. LOCK TABLE IN EXCLUSIVE MODE
this is what I'm concerned. Now, the "shutdown" a table gracefully
is solved. How about the whole postmaster (in some other situation),
how can I shut it down GRACEFULLY (i.e., I know tha
amy cheng wrote:
>
> hi, all experts there, greetings!
>
> Just minutes ago, my boss found out one of the attributes in a
> table is too short (varchar 64 for url), we need to make
> it wider to 85 A.S.A.P. Seems that alter table can not do it.
> So, I used pg_dump, (how to do it gracefully?) im
> hi, all experts there, greetings!
>
> Just minutes ago, my boss found out one of the attributes in a
> table is too short (varchar 64 for url), we need to make
> it wider to 85 A.S.A.P. Seems that alter table can not do it.
> So, I used pg_dump, (how to do it gracefully?) immediately drop the ta
hi, all experts there, greetings!
Just minutes ago, my boss found out one of the attributes in a
table is too short (varchar 64 for url), we need to make
it wider to 85 A.S.A.P. Seems that alter table can not do it.
So, I used pg_dump, (how to do it gracefully?) immediately drop the table,
shutd