RE: Clone object database

From: frank_lupo <frank_lupo(at)email(dot)it>
To: dpage <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: RE: Clone object database
Date: 2003-03-21 10:41:50
Message-ID: HC3HPQ$470684B223E132A3EA98EFDD8EA5E147@email.it
Views: Raw Message | Whole Thread | 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.
>

What you say to make?
Not to create the index?

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Tariffe promozionali per viaggiare in tutto il mondo, clicca e scopri dove prenotare
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1258&d=21-3

Browse pgadmin-hackers by date

  From Date Subject
Next Message efesar 2003-03-21 18:10:54 can't compile
Previous Message Dave Page 2003-03-21 10:16:19 Re: Clone object database