From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pet Peeves? |
Date: | 2009-01-29 20:43:38 |
Message-ID: | 20090129204338.GA4064@merkur.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2009-01-29 20:46:46 | Re: Pet Peeves? |
Previous Message | Ron Mayer | 2009-01-29 20:32:54 | Re: Pet Peeves? |