Merlin Moncure wrote:
In the context of this debate, I see this argument all the time, with
the implied suffix: 'If only we used integer keys we would not have
had this problem...'. Either the customer identifies parts with a
part number or they don't...and if they do identify parts with a
numbe
> Do the rows being updated contain
NULLs in the foreign-key columns?
No, all FK columns are non-NULL. It is very strange.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 4/16/07, Greg Smith <[EMAIL PROTECTED]> wrote:
I think the point Craig was trying to make is that what you refer to here
as "extraordinary cases" are, in fact, rather common. I've never seen a
database built on natural keys that didn't at some point turn ugly when
some internal or external bu
