Oliver Bienert wrote:
Thank you Oliver, I will make a file out of this example
and send it to David.
-- Massimo
Hello,
I had this problem with sqlite, which also does not (or did not)
support ON DELETE CASCADE. I used a trigger in the file
'session-create.sql':
create table rivet_session(
ip_address inet,
session_start_time timestamp,
session_update_time timestamp,
session_id varchar,
UNIQUE( session_id )
);
create table rivet_session_cache(
session_id varchar REFERENCES rivet_session(session_id) ON
DELETE CASCADE,
package varchar,
key varchar,
data varchar,
UNIQUE( session_id, package, key )
);
create index rivet_session_cache_idx ON rivet_session_cache(
session_id );
create trigger fkd_session_id
before DELETE ON rivet_session
for each row begin
DELETE FROM rivet_session_cache WHERE session_id = OLD.session_id;
end;
Regards Oliver
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
-- Massimo Manghi
-- Dipartimento di Biologia Evolutiva e Funzionale
-- Università degli Studi di Parma
-- Parco Area delle Scienze 11A - 43100 Parma
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
