Search Postgresql Archives

Re: PostgreSQL Gotchas

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

 



On Thu, Oct 06, 2005 at 05:29:14PM -0500, Jim C. Nasby wrote:
> On Thu, Oct 06, 2005 at 12:29:51PM -0700, David Fetter wrote:
> > * 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.
> 
> From the few times I've emailed the author he seems happy to accept
> better text.  I'm sure he'd be happy to mention slony as an upgrade
> option (though it would be best if there was a good doc describing
> this we could point to).  Likewise I believe he'd note things that
> will be fixed in a given version (such as 8.1 or 8.2).

I'll draft something up :)

> > * One deviation from the standard that won't be changed: fold-to-lower.
> 
> Does the standard even specify which case you fold to?

It specifies fold-to-upper, and that's just wrong. :P

> I agree, this is only a gotcha if you're used to the very
> non-standard behavior in MySQL.
> 
> > * Nits so minor as not to be worth addressing (non-optional AS in
> > FROM clauses vs. SQL standard's making that AS optional there)
> 
> *shrug* I think it's useful to be able to see why something you
> might expect to work doesn't.

I suppose it's good to have those.  There are other things I think of
as bugs, and would like to have addressed internally before I send
them off to gotchas land.  PG's incomplete support for DOMAINs, for
example, or the not-quite-it handling of composite types, or things
that are missing (imho) important features...

Cheers,
D
-- 
David Fetter david@xxxxxxxxxx http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[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