Re: [COMMITTERS] pgsql: Make pg_dump exclude unlogged table data on hot standby slaves

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-committers <pgsql-committers(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Make pg_dump exclude unlogged table data on hot standby slaves
Date: 2013-01-25 12:59:37
Message-ID: 20130125125937.GC4289@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 2013-01-25 13:56:11 +0100, Magnus Hagander wrote:
> On Fri, Jan 25, 2013 at 1:31 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> > On 2013-01-25 08:49:10 +0000, Magnus Hagander wrote:
> >> Make pg_dump exclude unlogged table data on hot standby slaves
> >
> > This missed the fact that there is no ExecuteSqlQueryForSingleRow and
> > surroundign infrastructure.
>
> Ugh, that's what I get for pushing something just before getting on a
> plane. Thanks for spotting.
>
> Fix looks good, except I'd just put the query text inline in PQexec()
> and not bother with a separate variable..

The query needs to get passed to check_sql_result and write_msg as well,
thats why I added the extra variable.

I don't think my -committers post got through (seems to be restricted),
so I am CCing -hackers so somebody else can see the patch.

Andres

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Attachment Content-Type Size
0001-Fix-backpatch-of-unlogged-table-check-for-pg_dump.patch text/x-patch 1.4 KB

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2013-01-25 13:01:15 Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves
Previous Message Magnus Hagander 2013-01-25 12:56:11 Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2013-01-25 13:01:15 Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves
Previous Message Magnus Hagander 2013-01-25 12:56:11 Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves