[pgpool-hackers: 1201] Re: Does pgpool-II support schema in FROM clause?

[Tatsuo Ishii]

> 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