| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "frank_lupo" <frank_lupo(at)email(dot)it> |
| Cc: | "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: Clone object database |
| Date: | 2003-03-21 10:16:19 |
| Message-ID: | 03AF4E498C591348A42FC93DEA9661B8259E0A@mail.vale-housing.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | frank_lupo | 2003-03-21 10:41:50 | RE: Clone object database |
| Previous Message | frank_lupo | 2003-03-21 10:02:12 | Re: Clone object database |