Re: URGENT: referential integrity problem

Stephan Szabo wrote:

> On Thu, 30 Jan 2003, pginfo wrote:
>
> >
> >
> > Stephan Szabo wrote:
> >
> > > On Wed, 29 Jan 2003, pginfo wrote:
> > >
> > > > Stephan Szabo wrote:
> > > >
> > > > > If you still have the dump you last used to import to 7.3 you might want
> > > > > to see if a new load of that data has integrity problems.
> > > >
> > > > As I checked the problem exists also in the dump from 7.2.3 ( before it was on
> > > > 7.2.1).I have this file backedup.
> > > > By importing in 7.3.1 the pg do not reported errors.
> > > > Only for example:
> > > > If I import data in oracle after importin it start integrity check and only if no
> > > > errors exeists it
> > > > commits data. And I was very supprised that pg do not check this thinks.
> > >
> > > It's a speed of load issue.  I think 7.3's dumps use alter table and will
> > > check.  Probably it'll eventually become optional.
> >
> > Hmm, as default option pg_dump on 7.3.1 do not check for reference integrity.I do not
> > know about any option for this case.
> > Which is the option?
>
> If you make a new constraint in 7.3, the dump from a 7.3 server should use
> ALTER TABLE to build the constraint.  That will check the data.  If you've
> imported a constraint from an earlier version it doesn't have the new
> constraint info and will still just dump them as triggers.  You can make
> the constraint information for those triggers (I think someone made a
> script to do that) but I'm not 100% sure what's involved.
>

No, I do not make any new constraint. All constraints was declared early.As I understande
7.3 remember the new constraints and by dumping it make check
for integrity only if this new constraints exists. Right?



I will search archive for such info. I trayed for 'integrity', but do not find the needet.

regards,
ivan.

> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org