[pgpool-general: 1249] Re: Dropping template1 through PGPool not possible

[Philip Hofstetter]

Hi,

On Fri, Dec 7, 2012 at 10:37 AM, Maik Kulbe <maik.kulbe+pgpool at gmail.com> wrote:

>> Unfortunately since DROP DATABASE cannot execute in a transaction
>> block and pgpool does not start an explicit transaction, DROP DATABASE
>> may causes inconsistency among backends. I don't think checking DROP
>> DATABASE can be executed beforehand is easy: there's always a window
>> between at the time check and actual execution of DROP DATABASE.
>>
>
> So is there any recommended way to execute such statements that PGPool can't
> handle that well?

just execute them on the master and have replication take care of them.

Philip