Re: Question about DEADLOCK

Hello,
You try load data first and then referential constraints

regards
Haris Peco
On Friday 22 November 2002 07:10 am, Savita wrote:
> Thanks Stephan,
>
> I wold like to know where to get LOCK manual/reference.
>
> And what is ther error number it will return when this error will come.Is
> there any work around this.HOw do I avoid this situation.
>
> --
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
> Stephan Szabo wrote:
> > On Fri, 22 Nov 2002, Savita wrote:
> > > Hi All,
> > >
> > > I have a question related to postgres.I have an application which is
> > > transferring data from MSSQL to Postgres at some regular interval.
> > >
> > > I had around 20,000 data in MSSQL which should be transferred to
> > > postgres. After transferring around 12000 data I got a error message
> > > ERROR: deadlock detected
> > > And after that data transfer has stopped.
> > >
> > > How to avoid this error and what is the reason for this error.
> >
> > Most likely cause would be a concurrent transaction doing something that
> > caused a foreign key to get into a dead lock situation (the current
> > implementation grabs overly strong locks).  In any case, we'll need more
> > information about what else was going on probably.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html