Re: BUG #6041: Unlogged table was created bad in slave node - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6041: Unlogged table was created bad in slave node
Date
Msg-id 25332.1306427674@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6041: Unlogged table was created bad in slave node  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: BUG #6041: Unlogged table was created bad in slave node
List pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Euler Taveira de Oliveira's message of jue may 26 12:00:05 -0400 2011:
>> I think we should emit the real cause in those cases, if possible (not too
>> much overhead). The message would be "Unlogged table content is not available
>> in standby server".

> I guess what it should do is create an empty file in the slave.

Probably it should, because won't the table malfunction after the slave
is promoted to master, if there's no file at all there?  Or will the
process of coming live create an empty file even if there was none?

But Euler is pointing out a different issue, which is usability.  If the
slave just acts like the table is present but empty, we are likely to
get bug reports about that too.  An error telling you you aren't allowed
to access such a table on slaves would be more user-friendly, if we can
do it without too much pain.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #6041: Unlogged table was created bad in slave node
Next
From: Emanuel Calvo
Date:
Subject: Re: BUG #6041: Unlogged table was created bad in slave node