Re: Strange phenomenon

From: "Joshua J(dot) Kugler" <joshua(at)eeinternet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martial Braem <Martial(dot)Braem(at)abboss(dot)be>
Subject: Re: Strange phenomenon
Date: 2010-10-15 22:37:35
Message-ID: 201010151437.36342.joshua@eeinternet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 15 October 2010, Scott Marlowe elucidated thus:
> On Fri, Oct 15, 2010 at 12:37 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > I'd look around for a cron job or some other periodic task that
> > thinks it's supposed to reload the database or something like that.
> >  Postgres doesn't forget stuff that easily ... unless it's told to.
>
> Had a search engine eat an entire database one night by clicking on
> the all the "delete" links.

And that was the night you learned about this part of RFC 2616 (HTTP
1.1), right? :)

"In particular, the convention has been established that the GET and
HEAD methods SHOULD NOT have the significance of taking an action other
than retrieval...Methods can also have the property of "idempotence" in
that (aside from error or expiration issues) the side-effects of N > 0
identical requests is the same as for a single request. The methods
GET, HEAD, PUT and DELETE share this property."

:)

--
Joshua Kugler
Part-Time System Admin/Programmer
http://www.eeinternet.com - Fairbanks, AK
PGP Key: http://pgp.mit.edu/  ID 0x73B13B6A

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-10-16 01:13:10 Re: Strange phenomenon
Previous Message John Iliffe 2010-10-15 21:12:50 Automated Database Backups