Re: PK referenced function

Поиск
Список
Период
Сортировка
От Serge Fonville
Тема Re: PK referenced function
Дата
Msg-id CAOAS_++UyWTLsN3CNZpWdKQrkaaVUFq1+3k+E7WGcdqvL2Ewiw@mail.gmail.com
обсуждение исходный текст
Ответ на PK referenced function  (Agustin Larreinegabe <alarreine@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi Augustin,

PostgreSQL has a couple of possibilities in this regard.
For example, http://stackoverflow.com/questions/1152260/postgres-sql-to-list-table-foreign-keys has a couple of very clear queries.

Additionally, it would be very useful if you could further clarify the problem you are trying to solve.

HTH


Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!


2013/9/6 Agustin Larreinegabe <alarreine@gmail.com>
Hi everyone:

I want to know if exists a postgres function or some easy way to know if a PK in a table is already referenced in another table/tables.

e.g.
I want to delete a row but first I've got to change or delete in the table/tables where is referenced, and I have many table where could be referenced. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Agustin Larreinegabe
Дата:
Сообщение: PK referenced function
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: PK referenced function