about creating DB - Mailing list pgsql-general

From hiroko
Subject about creating DB
Date
Msg-id 000b01c0b385$f39319a0$e801a8c0@d4.dion.ne.jp
Whole thread Raw
Responses Re: about creating DB  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: about creating DB  (will trillich <will@serensoft.com>)
List pgsql-general
hi all
 
we're switching our system from Unix-version to Linux-version,
and from SQLplus to PostgreSQL
 
the questions are about CREATING DB
 
I found that FOREIGN KEY clause, which we need for our DB, is not implemented on PostgreSQL.
that means you can't use DELETE CASCADE clause neither.
 
is there some alternative way for them????
llike, can't you use CHECK clause instead for them???
 
thankyou.
 
 
 
 
 
 
 

pgsql-general by date:

Previous
From: "Gyan"
Date:
Subject: query problem
Next
From: "hiroko"
Date:
Subject: Fw: about creating DB