Re: Deleting orphan records - Mailing list pgsql-general

From Jan Wieck
Subject Re: Deleting orphan records
Date
Msg-id 3E4985ED.5AE2AC1A@Yahoo.com
Whole thread Raw
In response to Re: Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
List 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@Yahoo.com #

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: corruption bug in 7.2.3-RH
Next
From: Hunter Hillegas
Date:
Subject: Measuring Performance/Tuning