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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-committers <pgsql-committers(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Make pg_dump exclude unlogged table data on hot standby slaves
Date: 2013-01-25 13:01:15
Message-ID: CABUevEx1CDTG3P_1495B=iVGaaobRQZ75pLi7_y9kW0HB=2d-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Jan 25, 2013 at 1:59 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> 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.

Ahh, gotcha.

> 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.

Ok! I just talked to Robert, and he's taking a look at it for me.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2013-01-25 13:43:06 pgsql: Eliminate use of ExecuteSqlQueryForSingleRow, which is not in 9.
Previous Message Andres Freund 2013-01-25 12:59:37 Re: [COMMITTERS] pgsql: Make pg_dump exclude unlogged table data on hot standby slaves

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-01-25 13:10:07 Re: proposal: fix corner use case of variadic fuctions usage
Previous Message Andres Freund 2013-01-25 12:59:37 Re: [COMMITTERS] pgsql: Make pg_dump exclude unlogged table data on hot standby slaves