From: | "Davidson, Robert" <robdavid(at)amazon(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-sql(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: [SQL] Function Parameters in GROUP BY clause cause errors |
Date: | 2006-03-23 13:30:28 |
Message-ID: | 8333C841129E074E9F83FC80676BA76E405230@exchg-sea3-03.ant.amazon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers pgsql-sql |
How amazing is that? I call it a night and come back to find that a bug has been identified and patched while I sleep.
When will it appear in the binaries (I see that the release version is still 8.1.3)? I thought about trying to compile from source, but after looking at the mingw page was too intimidated by figuring out what to download to try compiling source.
Best Regards,
Robert Davidson
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, March 22, 2006 8:27 PM
To: Davidson, Robert
Cc: pgsql-sql(at)postgresql(dot)org; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors
I wrote:
> Hmm, this seems like a plpgsql deficiency. It feels it can generate a
> separate parameter symbol ($n) for each occurrence of each variable it
> passes into a SQL query. But for this query to be legal, the two
> instances of IntervalMinutes have to be represented by the *same*
> parameter symbol (notice they are not in the regurgitated query).
> It would be more efficient anyway to not generate multiple parameters
> for the same value, so we oughta fix this.
Patch applied to HEAD and 8.1 branches.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-23 15:19:37 | Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292 |
Previous Message | Anita Lederer | 2006-03-23 11:27:06 | vacuum: invalid memory alloc request size 2684354556 |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2006-03-23 14:38:17 | Re: Accessing schema data in information schema |
Previous Message | Greg Stark | 2006-03-23 06:38:28 | Re: pgNixInstaller: Making PostgreSQL relocatable |
From | Date | Subject | |
---|---|---|---|
Next Message | Owen Jacobson | 2006-03-23 17:12:32 | Re: OUT parameter |
Previous Message | Tom Lane | 2006-03-23 04:27:11 | Re: [SQL] Function Parameters in GROUP BY clause cause errors |