Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQCdg-0003Ou-BT for pgsql-admin@arkaria.postgresql.org; Thu, 11 Apr 2013 08:13:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UQCdf-0005tl-OI for pgsql-admin@arkaria.postgresql.org; Thu, 11 Apr 2013 08:13:47 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQCde-0005td-FS for pgsql-admin@postgresql.org; Thu, 11 Apr 2013 08:13:46 +0000 Received: from zimbra1.eab.com.vn ([203.77.178.15]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQCdY-0003dr-Mb for pgsql-admin@postgresql.org; Thu, 11 Apr 2013 08:13:45 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra1.eab.com.vn (Postfix) with ESMTP id 0A2AC5A4086 for ; Thu, 11 Apr 2013 15:13:31 +0700 (ICT) X-Virus-Scanned: amavisd-new at zimbra1.eab.com.vn Received: from zimbra1.eab.com.vn ([127.0.0.1]) by localhost (zimbra1.eab.com.vn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ydnZgarC4hkf for ; Thu, 11 Apr 2013 15:13:30 +0700 (ICT) Received: by zimbra1.eab.com.vn (Postfix, from userid 102) id BD7195A4093; Thu, 11 Apr 2013 15:13:30 +0700 (ICT) Received: from THANHTOAN (unknown [192.168.69.69]) by zimbra1.eab.com.vn (Postfix) with ESMTPSA id 85D355A4086 for ; Thu, 11 Apr 2013 15:13:30 +0700 (ICT) From: =?iso-8859-1?Q?Ho=E0ng_Thanh_To=E0n_-_DB?= To: "'pgsql-admin'" References: In-Reply-To: Subject: Master/Slave mode: Temp table used by view Date: Thu, 11 Apr 2013 15:13:30 +0700 Message-ID: <004901ce368c$75a3e640$60ebb2c0$@com.vn> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004A_01CE36C7.2202BE40" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac42fkFSYhy53/cYSQ+mPj3Yrz5nVwADYpSQ Content-Language: en-us X-Copyrighted-Material: X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_004A_01CE36C7.2202BE40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear all, Please help me. I know this is postgres-admin mail list, it is not for the discussion of pgpool. I'm sorry to post questions related to pgpool. I have a problem like this: << I have a temporary table is used as a literal in View objects. in Master/Slave Mode (Pgpool): how to detect all query on this view, and then transfer it to master. >> Please give me some advices. Thanks a lot. -- Best Regards, ------=_NextPart_000_004A_01CE36C7.2202BE40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear all,

Please help me.

I know this is postgres-admin mail list, it is not for = the discussion of pgpool.

I'm sorry to post questions related to = pgpool.

I have a problem like this:

I have a temporary table is used as a literal in View = objects.

in Master/Slave Mode (Pgpool): how to detect all query on = this view, and then transfer it to master.

Please give me some advices.

Thanks a lot.

Best Regards,

=
= ------=_NextPart_000_004A_01CE36C7.2202BE40--