Re: about creating DB - Mailing list pgsql-general

From Limin Liu
Subject Re: about creating DB
Date
Msg-id 3ABF8724.8A614CCA@pumpkinnet.com
Whole thread Raw
In response to about creating DB  ("hiroko" <h_ogawa@rnk.co.jp>)
List pgsql-general
> the questions are about CREATING DB
>
> I found that FOREIGN KEY clause, which we need for our DB, is not >
implemented on PostgreSQL.

I believe, it's implemented called REFERENCES
http://www.postgresql.org/devel-corner/docs/postgres/sql-createtable.html

> that means you can't use DELETE CASCADE clause neither.

This one I am not sure, but seems can be implemented by adding one
trigger
http://www.postgresql.org/devel-corner/docs/postgres/sql-createtrigger.html


Have fun

--
LM Liu



pgsql-general by date:

Previous
From: "Mark Hamby"
Date:
Subject: Patch (tiny): \cd (change dir) for psql [with feedback]
Next
From: "Christian Marschalek"
Date:
Subject: PostgreSQL under Windows?