Re[2]: [SQL] data integrity

2000-08-15 Thread Sandis
Hello Jesus, Tuesday, August 15, 2000, 4:04:40 PM, you wrote: JA> The solution is called referential integrity. you should use the foreign JA> key and references clause with cascade. >> can someone suggest some good online resource where such common sql topics >> discussed? JA> I would like to

Re: [SQL] data integrity

2000-08-15 Thread Jesus Aneiros
On Tue, 15 Aug 2000, Sandis wrote: > there is a db with a few tables that have related (joined) fields. if > record in a one table (auxiliary) gets deleted (along with it's I would say this is the primary table. > primary key), reference to it in another table (main) points to And this is the

[SQL] data integrity

2000-08-15 Thread Sandis
Hello pgsql-sql, sorry for my question that is obviously a kind of lame and not related directly to postges, but i never dealt with it before & need an idea what to do right now. there is a db with a few tables that have related (joined) fields. if record in a one table (auxiliary) gets deleted