On 08/10/2012 10:26 PM, Rob Sargent wrote:
Seems like
for i == 1 to 10
select into table-with-bigint from table-with-int where
delete from table-with-bigint where
or any such fractionation scheme might do the trick
For that matter, you can ALTER TABLE .. ADD COLUMN the bigint column
without
On 08/10/2012 12:05 AM, John R Pierce wrote:
On 08/09/12 10:31 PM, Anibal David Acosta wrote:
I have a very big table, in fact only this table uses approx. 60%
space of disk.
The table is an standalone table (no one inherit from this and this is
not inherit from another).
I need to change a i
On 08/09/12 10:31 PM, Anibal David Acosta wrote:
I have a very big table, in fact only this table uses approx. 60%
space of disk.
The table is an standalone table (no one inherit from this and this is
not inherit from another).
I need to change a int column to bigint.
But aparentely this
I have a very big table, in fact only this table uses approx. 60% space of
disk.
The table is an standalone table (no one inherit from this and this is not
inherit from another).
I need to change a int column to bigint.
But aparentely this alter recreate the table, my problem is the space, th
