Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 55C1E476579
	for <pgsql-sql@postgresql.org>; Wed,  4 Dec 2002 14:36:43 -0500 (EST)
Received: from server45.aip.com.br (unknown [200.199.192.5])
	by postgresql.org (Postfix) with ESMTP id D9449476AC9
	for <pgsql-sql@postgresql.org>; Wed,  4 Dec 2002 14:28:18 -0500 (EST)
Received: from PEDRO ([10.1.0.11]) by server45.aip.com.br with SMTP (Microsoft
	Exchange Internet Mail Service Version 5.5.2653.13)
	id X40SXTLM; Wed, 4 Dec 2002 17:30:10 -0300
Message-ID: <000a01c29bca$0a245ed0$0b00010a@aip.com.br>
From: "Pedro Igor" <pedroigor@aip.com.br>
To: <pgsql-sql@postgresql.org>
Subject: Inheritance in PostgreSQL limitation
Date: Wed, 4 Dec 2002 17:19:16 -0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C29BB9.45D4E370"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/54
X-Sequence-Number: 10642

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C29BB9.45D4E370
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a database that uses inheritance, like this:
table2 inherits table1 where table1 has some relashionships (foreign key) w=
ith others four tables.
I trying to delete a record in table2 and i want all references in the tabl=
es that have the key of the table1 deleted.
I was reading some texts and found out that this is a PostgreSQL.
Has some one model some solution for this ?
I thinking of using triggers in the table2 that erases all references... Th=
is is a good idea or i just going to complicate ? Someone have a idea ?

Pedro Igor

------=_NextPart_000_0005_01C29BB9.45D4E370
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have a database that uses inheritance, l=
ike=20
this:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>table2 inherits table1 where table1 has so=
me=20
relashionships (foreign key) with others four tables.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I trying to delete a record in table2 and =
i=20
want&nbsp;all references in the tables that have the key of the table1=20
deleted.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I was reading some texts and found out tha=
t this is=20
a PostgreSQL.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Has some one model some solution for this=
=20
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I thinking of using triggers in the table2=
 that=20
erases all references... This is a good idea or i just going to complicate =
?=20
Someone have a idea ?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Pedro Igor</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C29BB9.45D4E370--