Re: about creating DB

Поиск
Список
Период
Сортировка
От Limin Liu
Тема Re: about creating DB
Дата
Msg-id 3ABF8724.8A614CCA@pumpkinnet.com
обсуждение исходный текст
Ответ на about creating DB  ("hiroko" <h_ogawa@rnk.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: "Mark Hamby"
Дата:
Сообщение: Patch (tiny): \cd (change dir) for psql [with feedback]
Следующее
От: "Christian Marschalek"
Дата:
Сообщение: PostgreSQL under Windows?