On Mon, Apr 21, 2008 at 12:24 PM, Colin Wetherbee <cww@denterprises.org> wrote:
> Right, but the problem I see is that my locations are not actually stored in
> foo. Since many rows of foo can reference the same location, the locations
> are stored in a separate table and, in fact, are referenced by foreign keys
> (SERIAL/INTEGER types) already.
I see, I haven't used PostGIS yet, so I am not sure how it is used.
However, I am curious about the advantages or the intent of having
duplicate points in a table that requires the surrogate ID in order to
be distinguished these duplicate point. I only ask since I am not
familiar with postGIS (perhaps this is the way it is intended to be
used.) To me this seems to be a bit de-normalized, unless there is
something that differentiates or somehow makes these points unique
these points.
If you constrained your data to only allowed unique points in your
points table, your problem would be solved in regards to caching,
since you could simple use natural foreign keys to get the connections
data that you want.
--
Regards,
Richard Broersma Jr.