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?
ALTER table "abcde" ALTER COLUMN "id" SET default nextval('seq_abcde');
SELECT pg_catalog.setval('seq_abcde',(SELECT max(id) from abcde),true);
DROP INDEX abcde_id;
CREATE INDEX abcde_id on abcde(id);
?
--
VULPE Dan
---
Detalii despre listele noastre de mail: http://www.lug.ro/
