| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | hiroko <h_ogawa(at)rnk(dot)co(dot)jp> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: about creating DB |
| Date: | 2001-03-26 03:13:08 |
| Message-ID: | Pine.LNX.4.30.0103252212100.11048-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve O'Hagan | 2001-03-26 03:31:12 | Linking M$ ACCESS to postgreSQL? |
| Previous Message | Brett W. McCoy | 2001-03-26 03:10:15 | Re: Free Text Search |