Re: Deleting orphan records

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Deleting orphan records
Дата
Msg-id 3E4985ED.5AE2AC1A@Yahoo.com
обсуждение исходный текст
Ответ на Re: Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: corruption bug in 7.2.3-RH
Следующее
От: Hunter Hillegas
Дата:
Сообщение: Measuring Performance/Tuning