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
"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
> 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
> 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
"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.
"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
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
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
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