Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-29 13:42:52
Message-ID: 4981B25C.9050804@archonet.com (view raw or flat)
Thread:
Lists: pgsql-general
Gregory Stark wrote:
> I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
> FOSDEM 2009 this year.

Hmm - three "niggles" things leap to mind.

1. Case-folding on column-names.
Quoting is a PITA sometimes when you're transferring from a different
DBMS. Be nice to have a "true_case_insensitive=on" flag.

2. Non-deferred unique checks
Merging two sets of data and renumbering pkeys is more fiddly than it
needs to be. Doesn't happen often, but it's one of the few things we
don't do "properly".

3. Date handling
Sometimes I've got data with invalid dates and it would be great if it
could replace all the bad ones with, say "0000-00-00".


You could throw in non-updateable views, exact-match tsearch queries,
per-statement triggers not having the old/new rowsets but that's more
things PG doesn't do rather than things it does.

-- 
  Richard Huxton
  Archonet Ltd

In response to

  • Pet Peeves? at 2009-01-29 13:16:17 from Gregory Stark

Responses

pgsql-general by date

Next:From: Tommy GildsethDate: 2009-01-29 13:42:59
Subject: Re: Text search segmentation fault
Previous:From: Tommy GildsethDate: 2009-01-29 13:41:29
Subject: Re: Text search segmentation fault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group