Re: [BUGS] BUG #3418: Memory leak with sql EXCEPTION?

2007-06-29 Thread Tom Lane
"Viatcheslav" <[EMAIL PROTECTED]> writes: > We are aware of additional costs of exceptions yet this one appears to be a > memory leak. AFAICT, the only memory consumed per-iteration by your example is the subtransaction XID that's added to the list of XIDs for eventual commit. It's not really poss

[BUGS] BUG #3418: Memory leak with sql EXCEPTION?

2007-06-29 Thread Viatcheslav
The following bug has been logged online: Bug reference: 3418 Logged by: Viatcheslav Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: RedHat Linux kernel 2.6.9-34.EL Description:Memory leak with sql EXCEPTION? Details: On our system we ca

Re: [BUGS] BUG #3417: Foreign key constraint violation occurs unexpectedly

2007-06-29 Thread David Boesch
Gregory, Thanks for the reply. The data has been added via a file, as it is static data, no user input for this table, and yes I have run the file many times. I have accidently left some information out however that I believe will probably add some light on this. The data has been added to this