Re: TRICKY TRIGGER QUESTION

My apology too, I didn't mean to post any rude message. We have primary key as composite key and value of some of the columns will change. Very difficult to prohibit developers and users from not changing primary key. And overall, "unique primary key" rule is maintained any way.

I like to design in such a way that primary key don't change (delete/insert is okay) but then, even in C. J. Date's book, I don't see any reference to "primary key change is intrinsically wrong".

Interestingly, Oracle Vs Sybase people can add one more item in favor or Oracle!

Thanks,
Sunil PRajapati

In article <5t1v9n$16r_at_mew.corp.sgi.com>,   pablo_at_sgi.com wrote:
>
>
> In article <33EFF410.1739_at_tiac.net>, "Summit International, Inc."
 <summ_at_tiac.net> writes:
> > Pablo Sanchez wrote:
> > >
> > > In article <870965629.3791_at_dejanews.com>, sprajapa_at_fmrco.com writes:
> > > >
> > > > I need to capture primary key changes. Let's say, my update statement
> > > > changes primary key of 10 rows (assumeing primary key as int, values
> > > > 1, 2, 3...10 and new values are 1101, 1102, 1103, ... 1110), then I want
> > >
> > > Doesn't it sound intrinsically wrong to be changing a primary key?
> > > If yur changing it, it ain't primary.
> >
> > Hummm, I didn't expect such reply from you, Pablo, Let's call it "key to
> > identify existing row at given moment" instead of "primary key", now do
> > we have solution ?
>
> Perhaps the tone was off... my apologies if it sounded insolent...
> anyway, the answer is yes, now we have a solution because the primary
> key will not change... the other keys may change but the primary key
> will not, therefore you'll be able to join across the deleted and
> inserted tables.
> --
> Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p_at_pager.sgi.com
> --------------+-----------------+--------------------------------------------
> pablo_at_sgi.com ... when mailing me, place "not spam" in the Subject

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet