No title

Started by Agustin Larreinegabeover 12 years ago2 messages
#1Agustin 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.

#2Serge Fonville
serge.fonville@gmail.com
In reply to: Agustin Larreinegabe (#1)
Re:

Hi Agustin,

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.
Unfortunately, this is not the correct mailing list.

Instead you should ask these types of questions on either NOVICE or GENERAL.
http://www.postgresql.org/community/lists/

HTH

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

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&gt;

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

Show quoted text

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.