Re: PostgreSQL Gotchas

On Thu, 2005-06-10 at 12:07 -0600, Aly S.P Dharshi wrote:
> http://sql-info.de/postgresql/postgres-gotchas.html
>
> Any comments from folks on the list ?

"SELECT column alias, ...": this is a known issue. AFAIK it is not easy
to solve.

"Unquoted object names fold to lower case": this is intentional, both
because the developers prefer this behavior and because it is consistent
with the behavior of prior PostgreSQL versions.

"Implicit FROM item and unintended cross joins": fixed in 8.1, as the
gotcha notes.

"COUNT(*) very slow": this is a known issue -- see the -hackers archives
for many prior discussions. MVCC makes this hard to solve effectively
(whether applications should actually be using COUNT(*) on large tables
with no WHERE clause is another matter...)

-Neil