On Fri, 24 Sep 2004, cristivoinicaru wrote:
> Am o tabela cu urmatoarea structura:
>
> create sequence seq_abcde;
> create table abcde (id integer defaul nextval('seq_abcde'),
> nume varchar(10)
> );
> create unique index abcde_id on abcde (id);
>
> In urma unor operatii de copiere am ajuns la structura:
> create table abcde ( id integer,
> nume varchar(10)
> );
>
> Cum pot aduce tabela la starea initiala si reface index_ul?
Ce inseamna stare initiala?
delete from tabela;
select setval('seq_abcde', 1, 't');
sau:
alter table tabela alter column id set default nextval('seq_abcde');
?
In cazul 1 ar fi bine sa vacuum full tabela, in cazul 2 poti sa
lasi indexul in pace. Sau daca ti-a disparut si indexul atunci il
refaci.
Daca la tine se potriveste varianta 2 atunci vezi tipurile
serial si bigserial. Is tot int (int4) respectiv bigint (int8) insa
sequence-urile se creaza automat (no big deal insa e o mica
automatizare a problemei).
--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.
---
Detalii despre listele noastre de mail: http://www.lug.ro/
