Thread: Re: Clone object database

Re: Clone object database

From
"Dave Page"
Date:

> -----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.