Skip site navigation (1) Skip section navigation (2)

Re: Clone object database

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: (view raw, whole thread or download thread mbox)
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.

pgadmin-hackers by date

Next:From: frank_lupoDate: 2003-03-21 10:41:50
Subject: RE: Clone object database
Previous:From: frank_lupoDate: 2003-03-21 10:02:12
Subject: Re: Clone object database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group