Re: Deleting orphan records

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: John Smith <john_smith_45678(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Deleting orphan records
Date: 2003-02-11 23:23:25
Message-ID: 3E4985ED.5AE2AC1A@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Smith wrote:
> Are there plans to implement PENDANT?

Not that I know of. I think you can work around it with a custom
triggers on UPDATE and DELETE on the child rows, that then do a DELETE
on the parent table using OLD.fkey (if OLD.fkey != NEW.fkey in the
UPDATE case of course).

> Sorry about the MIME emails - can't figure out how to get Yahoo to
> send text (I see you use Yahoo - how's it done? ;) ).

By having your own IMAP server on a Linux box at home, polling the mail
from Yahoo! and other accounts with fetchmail, filtering it for SPAM
with procmail and some Tcl scripts and then using Netscape with roaming
profile and SSL IMAP connections to access your mailboxes from wherever
you are. Since you need Apache for the roaming profile server anyway,
you may also install SquirrelMail so you can get at you mail from any
browser via https.

Sorry, you asked the wrong guy for this ;-)

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hunter Hillegas 2003-02-12 00:17:58 Measuring Performance/Tuning
Previous Message Dennis Gearon 2003-02-11 22:58:40 Re: corruption bug in 7.2.3-RH