Re: postgres database crashed

Hi, Ashish,

Ashish Goel wrote:

> I am sorry but I forgot to mention that in the database schema we are
> maintaining referrences to the main table xyz(int id, img image, fname
> varhcar(50))
>
> There are around 14 tables referrencing this table . The referrences are
> being made to the column id.
>
> The code works well if we don't maintain the referrences but when we
> include the referrences then the database crashes somewhere between
> 2500-3000 transactions.
>
> So could this problem be due to the multiple referrences being made to
> the same table ?

I doubt so.

Foreign key references are among the basics of SQL, they're pretty well
tested.

Could you try to replace your image type e. G. with bytea for your test
purposes, and see, whether it crashes, too?

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org