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

2007-07-03 Thread Viatcheslav Kalinin
Hello, Tom As of you last mail: > Well, if you think there's some other memory leak then you need to > submit a test case that demonstrates it. Not to be going to make any assumptions on what might be malfunctioning internally, I populated a test case that at least on our system demonstrates

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> writes: >> From: Tom Lane [mailto:[EMAIL PROTECTED] >> Hm, I would've thought HEAD actually. What does select version() say? > PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.0 > (It's definitely not 8.2.4 but perhaps 8.2.4 + 1/2) Yeah, we

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > I am getting NO DATA on queries that attempt to match one of the "outer" > > rows generated by an outer join. > > Your test case works fine for me on CVS HEAD and 8.2 branch tip. I > think it is another

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > I installed postgresql-snapshot.tar.bz2 2007-07-03 10:18:42 from > > stable_snapshot and confirm that the problem does not reproduce there. (I > > assume that this snapshot is 8.2 branch tip and CVS HEAD

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> writes: > I installed postgresql-snapshot.tar.bz2 2007-07-03 10:18:42 from > stable_snapshot and confirm that the problem does not reproduce there. (I > assume that this snapshot is 8.2 branch tip and CVS HEAD is 8.3 dev?) Hm, I would've thought HEAD actually.

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> writes: > I am getting NO DATA on queries that attempt to match one of the "outer" > rows generated by an outer join. Your test case works fine for me on CVS HEAD and 8.2 branch tip. I think it is another manifestation of this bug: http://archives.postgresql.org

[BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
The following bug has been logged online: Bug reference: 3426 Logged by: David Flater Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: GNU/Linux Description:Rows disappear from complex join Details: Hello, I am getting NO DATA on queries

Re: [BUGS] BUG #3424: Not able to drop trigger(RI_trigger*) on specific table.

2007-07-03 Thread Heikki Linnakangas
S R Madhu wrote: We have created a table "student". Foreign key and triggers are created in student. We are able to map triggers and constraints from pg_class table. We have used following mapping mechanism to get the trigger name. pg_class.relfilenode -> pg_trigger.tgrelid. We have used foll

[BUGS] BUG #3424: Not able to drop trigger(RI_trigger*) on specific table.

2007-07-03 Thread S R Madhu
The following bug has been logged online: Bug reference: 3424 Logged by: S R Madhu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux RH6.2 Description:Not able to drop trigger(RI_trigger*) on specific table. Details: We have created