From: | Kostis Mentzelos <mentzelos(at)ematic(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: rename a table |
Date: | 2001-06-22 08:35:41 |
Message-ID: | 3B33035D.BF660A39@ematic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have just realized that I don't need the sequence
any more, because when I rename the table I will never insert
a raw in it.
Thanks.
Dennis wrote:
>
> // first simply
> drop sequence data_b_seq;
>
> // then create the table as you would. before.
>
> -Dennis
>
> Kostis Mentzelos wrote:
>
> > Hi all,
> >
> > I want to rename a table from DATA to 'unique' every month
> > and then recreate table DATA. (a number of applications works
> > with table DATA)
> >
> > DATA contains among the others a SERIAL field.
> >
> > create table DATA (a int, b serial,...);
> >
> > I tried ALTER TABLE DATA RENAME TO XXXX but
> > when I recreate table DATA I get this error:
> > relation 'data_b_seq' already exists.
> >
> > Is there any way to rename sequences?
> > Is it better to create the new table, copy 1.000.000 to the new
> > table and then delete them from DATA and then VACCUM the
> > database?
> >
> > kostis.
> >
> > ---------------------------------------------------------------
> > Why do I need to do such a thing?
> > I think that I need to do this because I have 1.000.000
> > tuples/month and I don't want to work into a very big table.
> > So 'I said' I have to find a way to move table DATA to something
> > else and then recreate table DATA. This way I am going to
> > work into a table of maximum 1.000.000 tuples at the end of
> > the month.
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Gunnar Rønning | 2001-06-22 11:42:12 | Re: Re: [ADMIN] High memory usage [PATCH] |
Previous Message | Rainer Mager | 2001-06-22 04:56:17 | RE: Re: [ADMIN] High memory usage [PATCH] |