On Fri, 24 Sep 2004 [EMAIL PROTECTED] wrote:
> 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);
=====================
Mai bine:
REINDEX INDEX abcde_id;
Pt. mai multe vezi www.postgresql.org sau google.
--
VULPE Dan
---
Detalii despre listele noastre de mail: http://www.lug.ro/
