Re: Timing Race

On Sunday 21 February 2010 10:38:18 am Dennis Gearon wrote:
> Version 8.4 on Ubuntu Linux (is this still supported?)

It is the most current stable version, so yes it is supported.

>
> I'm getting an error upon inserting a copy version of a database dump. It's
> very simple, 4 tables,
>
> TableA 2 records (basically a lookup table)
> TableB 15 records
> TableC 46 records ( many side of 'one to many')
> TableD 55 records.( one side of 'one to many')
>
> Each table has a sequence, one has an index.
>
> TableC has a Foreign key to TableD (child/parent respectively)
> TableD has a Foreign Key to TableA (child/parent respectively)
>
> The problem I get is that inserting the copy into a blank database gives me
> errors when it gets to TableD because 2nd record in TableA seems not to be
> available to reference for the foreign key in TableD. It doesn't even
> matter if I rearrange the database dump contents to insert all the parents
> first, it always fails there.

A couple of questions.
1) Are you dumping/restoring from the same version to same version?
2) What do your dump command and restore commands look like?

>
> However, if I split the file up, and do one table at a time, it works just
> fine. Is this a known issue, feature, or I am doing something wrong? I
> thought that doing a database recovery using a copy version of a dump would
> be a no brainer, it would happen all in one transaction?

I am not sure what you mean by a copy version?

>
>
> Dennis Gearon
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com