On Fri, 23 Mar 2001, hiroko wrote:
> 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???
Foreign keys have been available in PostgreSQL since version 7.0. Please
see the online documentation.
-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
You can do more with a kind word and a gun than with just a kind word.
- Al Capone