On Thu, Oct 06, 2005 at 12:07:12PM -0600, Aly S.P Dharshi wrote:
> http://sql-info.de/postgresql/postgres-gotchas.html
>
> Any comments from folks on the list ?
Several.
First, it looks to me like this is a pretty transparent attempt to
troll, so I'm not going to go there.
Second, if you actually go through that list, you find:
* Problems fixed in the last version or three of PostgreSQL. This is
an incentive to upgrade, not a gotcha.
* Problems that will be fixed in the next version of PostgreSQL.
This means that problems get on developers' radar and get fixed. I
suppose by some extremely un-generous method of assessment, this
could be a gotcha.
* Incomplete information, e.g. not mentioning Slony-I as an upgrade
path.
* One deviation from the standard that won't be changed: fold-to-lower.
* Nits so minor as not to be worth addressing (non-optional AS in FROM
clauses vs. SQL standard's making that AS optional there)
Third, there are real gotchas, but those are generally reported as
bugs on pgsql-bugs and acted upon as such.
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!