Thanks. You mean to say that if we use Master/Slave mode, we do not need to install pgpool_regclass at all? if not for timestamp, is there any other place where pgpool_regclass will be used in Master/Slave mode?
________________________________ From: Tatsuo Ishii <[email protected]> To: [email protected] Cc: [email protected]; [email protected] Sent: Wed, April 13, 2011 1:19:31 PM Subject: Re: [Pgpool-general] Test case for pgpool-regclass > I thought without pgpool_regclass, the pgpool will drop the schema name from >the > > query (SELECT statement). No. > Anyways, I use Master/Slave mode with sub mode as 'stream'. Replication mode > is > > off. I have one Master (port 5432) and one Slave (5433) > > I did the following steps to create table and then executed select query to > see > > the timestamp on both the nodes and they are same. I have not installed > pgpool_regclass yet. > > Am I missing anything? Oh ok, in master/slave mode, timestamp rewriting is not peformed. So you don't need to install pgool_regclass. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp >> I just wanted to test the use of pgpool-regclass. I took the sources of >> pgpool-II 3.0.3 and PG9.0. I did not install pgpool-regclass to check the >> pgpoo-II's behaviour in case of missing pgpool-regclass. >> >> Here, is what I did: >> 1. Created a table t1 in the public schema, and inserted some values in it. >> 2. Created a schema sch1 and created a table t1 in this schema, and inserted >> some values in it. >> >> Then, how I execute, >> >> psql -p 9999 -c "select * from schema1.table1" >> >> I thought, without regclass, this should fallback to : >> psql -p 9999 -c "select * from table1" >> >> But NO, I get the values from the table present in schema1. That means, it >> is >> working fine. > > No. pgpool_regclass does not affect user's SELECT itself. > > If you are using pgpool-II in replication mode, you could check the > effect as follows: > > create table schema1.table1(t timestamp default current_timestamp); > create table public.table1(t int default 100); > set search_path to schema1,public; > insert into table1 values(default); > > If you install pgpool_regclass, your database nodes have exactly same > timestamp values because pgpool rewrite the query correctly. > > On the other hand, if you do not install it, your database nodes have > different timestamp values because pgpool does not recognize that > table1 has timestamp column and needs to be written. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
