Re: about creating DB

From: Limin Liu <limin(at)pumpkinnet(dot)com>
To: h_ogawa(at)rnk(dot)co(dot)jp, pgsql-general(at)postgresql(dot)org
Subject: Re: about creating DB
Date: 2001-03-26 18:15:00
Message-ID: 3ABF8724.8A614CCA@pumpkinnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-26 18:22:56 Re: Re: Call for platforms
Previous Message Christian Marschalek 2001-03-26 18:13:58 PostgreSQL under Windows?