On Fri, 2003-08-22 at 05:01, sharvari N wrote:
> hello
> How do i change the definition of a column? one of the columns width is
> not sufficient to store the data. I want to change the width. how to do
> that in postgres? I tried doing alter table + change/modify. both of
> them doesn't work in p
hello
How do i change the definition of a column? one of the columns width is not sufficient to store the data. I want to change the width. how to do that in postgres? I tried doing alter table + change/modify. both of them doesn't work in postgres.
and what is the maximum size to which a post
Late as it is, I'll try this monday. I hope it works, other suggestions
still welcome of course, thanks very much.
On Fri, 27 Jun 2003, Tom Lane wrote:
> Sam Barnett-Cormack <[EMAIL PROTECTED]> writes:
> > [ accidentally clobbered pg_control ]
>
> It sounds like the main problem is too small a va
Sam Barnett-Cormack <[EMAIL PROTECTED]> writes:
> [ accidentally clobbered pg_control ]
It sounds like the main problem is too small a value in the XID
(transaction ID) counter, so that all your data tuples appear to be in
the future. pg_resetxlog has an option to force an initial XID but
you nee
I have a problem partly caused by stupidity, which I desperately need to
fix if at all possible. Me and a colleague have tried fixing it and
may've made it worse...
I have a reasonably big db (21GB on disk, fully vaccuumed). I upgraded
from 7.3.2 to 7.3.3, forgetting to shut it down cleanly first.
