Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Function Parameters in GROUP BY clause cause errors

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-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

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2006-03-23 14:38:17
Subject: Re: Accessing schema data in information schema
Previous:From: Greg StarkDate: 2006-03-23 06:38:28
Subject: Re: pgNixInstaller: Making PostgreSQL relocatable

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-03-23 15:19:37
Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Previous:From: Anita LedererDate: 2006-03-23 11:27:06
Subject: vacuum: invalid memory alloc request size 2684354556

pgsql-sql by date

Next:From: Owen JacobsonDate: 2006-03-23 17:12:32
Subject: Re: OUT parameter
Previous:From: Tom LaneDate: 2006-03-23 04:27:11
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group