[BUGS] BUG #3423: cache on temporary tables in plpgsql

2007-07-01 Thread vituko
The following bug has been logged online: Bug reference: 3423 Logged by: vituko Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: debian sarge Description:cache on temporary tables in plpgsql Details: "relation with OID # does not exist"

Re: [BUGS] BUG #3423: cache on temporary tables in plpgsql

2007-07-01 Thread Pavel Stehule
Hello It's not bug. Solution is simple. You cannot drop temp table ever. Temp table is automaticly dropped when session is aborted. http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL In PostgreSQL 8.3 this problem is solved. Regards Pavel Stehule 2007/6/30, vituko <[EM

[BUGS] BUG #3422: Segmentation violation in PL/pgSQL

2007-07-01 Thread Holger Schurig
The following bug has been logged online: Bug reference: 3422 Logged by: Holger Schurig Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL 8.3d Operating system: Linux Description:Segmentation violation in PL/pgSQL Details: PostgreSQL CVS from today Sk

Fwd: [BUGS] BUG #3421: Failed to create temporary batch file

2007-07-01 Thread Jaime Casanova
-- Forwarded message -- From: Fadi Thabtah <[EMAIL PROTECTED]> Date: Sun, 1 Jul 2007 12:56:52 +0100 Subject: RE: [BUGS] BUG #3421: Failed to create temporary batch file To: Jaime Casanova <[EMAIL PROTECTED]> yes I do. Fadi From: Jaime Casanova [

Re: [BUGS] BUG #3422: Segmentation violation in PL/pgSQL

2007-07-01 Thread Tom Lane
"Holger Schurig" <[EMAIL PROTECTED]> writes: > Description:Segmentation violation in PL/pgSQL Can you provide a gdb stack trace for this? regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the p

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

2007-07-01 Thread Tom Lane
Viatcheslav Kalinin <[EMAIL PROTECTED]> writes: > I've made two cases actually, simple one that I already mentioned about > in my previous mails and more complex one that I tried to make somewhat > close to our work case where I first encountered the problem in question. As I said before, the on