Search Postgresql Archives

Re: PostgreSQL Gotchas

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Oct 06, 2005 at 01:19:33PM -0600, Aly S.P Dharshi wrote:
> Okay that is a fair statement to make, hence restating:
> 
> - What is the status of those items listed on the PostgreSQL gotchas

Some of them are for sure gotchas.  For users of
tranditionally-non-toy (as opposed to recently-non-toy) systems, I'd
think that there are three serious issues: the column alias
(because it strictly violates the SQL definition), the folding to
lower case (same reason), and the UNICODE==UTF-8 issue (because it
violates the UNICODE definition).

> - Are they valid statements ?
> - If they are bugs are they resolved ?

Some of them are valid and resolved (the site actually notes as much
in many cases).  

One thing I do note is that there's a workaround for the have-to-dump
issue: you can use Slony to upgrade (by design).  It won't work for
everyone, but it's a big step up in many cases.

A

-- 
Andrew Sullivan  | ajs@xxxxxxxxxxxxxxx
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux