Postgres Pro
Downloads
Home   >   mailing lists

Re: PK referenced function - Mailing list pgsql-general

From Serge Fonville
Subject Re: PK referenced function
Date
Msg-id CAOAS_++UyWTLsN3CNZpWdKQrkaaVUFq1+3k+E7WGcdqvL2Ewiw@mail.gmail.com
Whole thread Raw
In response to PK referenced function  (Agustin Larreinegabe <alarreine@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Agustin Larreinegabe
Date:
Subject: PK referenced function
Next
From: Michael Paquier
Date:
Subject: Re: PK referenced function