From: | Serge Fonville <serge(dot)fonville(at)gmail(dot)com> |
---|---|
To: | Agustin Larreinegabe <alarreine(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-novice-owner(at)postgresql(dot)org |
Subject: | Re: PK referenced function |
Date: | 2013-09-06 13:29:32 |
Message-ID: | CAOAS_++UyWTLsN3CNZpWdKQrkaaVUFq1+3k+E7WGcdqvL2Ewiw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-keyshas
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
Convince Microsoft!
Please don't get rid of the MCM and MCA
programs<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table>
2013/9/6 Agustin Larreinegabe <alarreine(at)gmail(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-09-06 13:51:08 | Re: PK referenced function |
Previous Message | Agustin Larreinegabe | 2013-09-06 13:26:08 | PK referenced function |