On Thu, Jan 29, 2009 at 02:22:28PM -0300, Alvaro Herrera wrote: > > I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at > > FOSDEM 2009 this year. I have a pretty good idea what some them are of course, > > but I would be interested to hear if people have any complaints from personal > > experience. What would be most interesting is if you can explain an example of > > when the problem caused real inconvenience to you, since sometimes it's hard > > to see from a theoretical description where the real harm lies. > > > > So, what do people say? Is Postgres perfect in your world or does it do some > > things which rub you the wrong way? > > No foreign keys in inheritance trees +1 Or, in other words, no indices across table (am I wrong ?). GNUmed uses table inheritance quite extensively and could save an additional key column per child table. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
