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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
