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.
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
> 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
pgsql-hackers by date
|Next:||From: Hannu Krosing||Date: 2006-03-23 14:38:17|
|Subject: Re: Accessing schema data in information schema|
|Previous:||From: Greg Stark||Date: 2006-03-23 06:38:28|
|Subject: Re: pgNixInstaller: Making PostgreSQL relocatable|
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-03-23 15:19:37|
|Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292 |
|Previous:||From: Anita Lederer||Date: 2006-03-23 11:27:06|
|Subject: vacuum: invalid memory alloc request size 2684354556|
pgsql-sql by date
|Next:||From: Owen Jacobson||Date: 2006-03-23 17:12:32|
|Subject: Re: OUT parameter |
|Previous:||From: Tom Lane||Date: 2006-03-23 04:27:11|
|Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors |