Re: Hot Standby status

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Hot Standby status
Date: 2009-11-10 20:11:07
Message-ID: 58A1BA79-7760-47F9-9896-6E1855C61836@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Nov 10, 2009, at 13:36 , Heikki Linnakangas wrote:

> Attached is the latest and greatest patch against CVS head, taken from
> the hs-riggs branch in my git repository.

Awesome. Thank you, Simon and Heikki!

I skimmed through the documentation to get a better handle on what
this will mean.

> + <para>
> + These actions produce error messages
> +
> + <itemizedlist>
> + <listitem>
> + <para>
> + DML - Insert, Update, Delete, COPY FROM, Truncate.
> + Note that there are no actions that result in a trigger
> + being executed during recovery.
> + </para>
> + </listitem>
> + <listitem>
> + <para>
> + DDL - Create, Drop, Alter, Comment (even for temporary
> tables because
> + currently these cause writes to catalog tables)
> + </para>
> + </listitem>

Other commands are in all-caps. Any reason INSERT, UPDATE, DELETE,
TRUNCATE, CREATE, DROP, ALTER, and COMMENT are not?

Cheers,

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-11-10 21:43:15 Re: [HACKERS] PostgreSQL 8.3.8 on AIX5.3 : compilation failed
Previous Message Devrim GÜNDÜZ 2009-11-10 20:00:30 Re: Hot Standby status