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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
