Re: Clone object database - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Clone object database
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8259E0A@mail.vale-housing.co.uk
Whole thread Raw
List pgadmin-hackers

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo@email.it]
> Sent: 21 March 2003 10:02
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] Clone object database
>
>
> > 5) 'System' indexes (such a created by Primary Key or Unique
> > constraints) will also be manually recreated.
>
> I do not understand.
> You can explain to me better?

Because you recreate all indexes, you also recreate indexes that
implement constraints and pkeys, so you might end up with 2 unique
indexes on one column - one created by the unique constraint, and one
created by the index copy.

Regards, Dave.

pgadmin-hackers by date:

Previous
From: "frank_lupo"
Date:
Subject: Re: Clone object database
Next
From: "frank_lupo"
Date:
Subject: RE: Clone object database