Re: [SQL] surrogate key or not?

2004-08-07 Thread Kenneth Gonsalves
On Sunday 08 August 2004 06:36 am, Oliver Elphick wrote: > On Sat, 2004-08-07 at 05:00, Kenneth Gonsalves wrote: > > why shouldnt the primary key change? the only key that should never > > change is a key that is used as a foreign key in another table. In a > > table like this: > > > > id serial un

Re: [SQL] surrogate key or not?

2004-08-07 Thread Oliver Elphick
On Sat, 2004-08-07 at 05:00, Kenneth Gonsalves wrote: > why shouldnt the primary key change? the only key that should never change is > a key that is used as a foreign key in another table. In a table like this: > > id serial unique > name varchar primary key > > name may change - id will never

Re: [SQL] reply to setting

2004-08-07 Thread Tom Lane
Kenneth Gonsalves <[EMAIL PROTECTED]> writes: > any reason why the default reply-to on this list should not be set to the > list? I keep replying to postings only to find later that the reply goes to > the OP and not to the list. reply-all button results in needless duplication It works fine for