| From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem with FKEYS |
| Date: | 2003-11-13 16:24:29 |
| Message-ID: | 3FB3B03D.9030809@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid8857(dot)1068651617(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">Rajesh Kumar Mallah <a class="moz-txt-link-rfc2396E" href="mailto:mallah(at)trade-india(dot)com"><mallah(at)trade-india(dot)com></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">How come pgsql7.3.4 Was allowing me to delete the master record while
referencing records were present in slave table?
</pre>
</blockquote>
<pre wrap=""><!---->
The only explanation I can think of is that the referencing row shown as
being in user_services was actually in a child table --- foreign keys
don't work in inheritance hierarchies at the moment.</pre>
</blockquote>
<br>
No, That is not the case , they are plain tables.<br>
<br>
<blockquote type="cite" cite="mid8857(dot)1068651617(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">
If that's not it, can you provide a self-contained example?</pre>
</blockquote>
Could not replicate it with newly created tables. Only those set of
table<br>
has the problem. I am ready to provide any required info .<br>
<br>
Regds<br>
Mallah.<br>
<br>
<blockquote type="cite" cite="mid8857(dot)1068651617(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
<a class="moz-txt-link-freetext" href="http://archives.postgresql.org">http://archives.postgresql.org</a>
</pre>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Ruth | 2003-11-13 17:00:41 | Re: Column Sizes |
| Previous Message | Bruce Momjian | 2003-11-13 16:24:07 | Re: [HACKERS] Proposal for a cascaded master-slave replication system |