I have a suspicion that the version might be different. I have the same symptom here on two different RH 7.3 boxes one running 7.3.2 and the other running 7.3.3
It would appear 7.3.2 is more strict about the naming of the GROUP BY fields.
David Olbersen wrote:
Culley,
But on my production machine postgresql complained about the order by
clause-- it wanted the table alias to be on last_name.
I believe this is because you used "u.last_name" earlier in the statement, and the ORDER BY clause doesn't know that's what you mean.
That's a guess that doesn't really explain why it'd work under one OS and not under another. Are the two versions of Postgres configured the same?
--------------------------
David Olbersen
iGuard Engineer
St. Bernard Software
-----Original Message-----
From: culley harrelson [mailto:culley@fastmail.fm]
Sent: Friday, August 08, 2003 10:48 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] 7.3.3 behaving differently on OS X 10.2.6
and FreeBSD
4.8-STABLE
I don't know if this is a postgresql bug or a problem with my
architecture but I thought I would post here about a strange
bug I just
came across in my application.
I use OS X 10.2.6 as my development machine and FreeBSD 4.8 for my
production machines. All systems are running postgresql
7.3.3. I just
published some code to production and when testing the production
results it blew up with a sql parsing error. The following
sql worked
fine on my OS X development machine:
select u.user_id, u.first_name, u.last_name, u.email_address, w.w9,
pm.description as payment_method, count(s.user_id) as documents,
sum(s.payment_amount) as amt_sum from ht_user u inner join
writer w on
u.user_id = w.user_id inner join payment_method pm on
w.payment_method_id = pm.payment_method_id left join submission s on
u.user_id = s.user_id group by u.user_id, u.first_name, u.last_name,
u.email_address, w.w9, pm.description order by lower(last_name) asc
But on my production machine postgresql complained about the order by
clause-- it wanted the table alias to be on last_name.
culley
---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend