[pgpool-hackers: 1201] Re: Does pgpool-II support schema in FROM clause?
Tatsuo Ishii
ishii at postgresql.org
Wed Dec 9 23:35:50 JST 2015
> Hi,
>
> Sorry for this newbie question for pgpool-II.
>
> Does pgpool-II support "schema.table" table in FROM clause?
>
> I'm using pgpool-ii V3.4.3 and found that table with schema
> is cached by SELECT statement and that cached is returned to
> next same SELECT as result.
> But after did DML to that table. Cache is not clear and
> the SELECT's result is the old one.
Works for me.
test=# create table t1 (i int);
CREATE TABLE
test=# insert into t1 values(1);
INSERT 0 1
test=# select * from public.t1;
i
---
1
(1 row)
test=# insert into public.t1 values(2);
INSERT 0 1
test=# select * from public.t1;
i
---
1
2
(2 rows)
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-hackers
mailing list