> -----Original Message----- > From: frank_lupo [mailto:[EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
