[pgpool-general: 2552] Re: Restrictions

[Tatsuo Ishii]

> Hitting space bar sent the mail before I completed it.Sorry.To continue -
> Does this mean a query of type
> "with myt as (select ..) select * from "
> or it applies to only queries where we insert into one table and then using
> RETURNING clause modify data in another table?
> Regards,
> Jayadevan

"Multi statement query" means that a query consists of multiple
queries separated by ";". For example,

BEGIN;SELECT 1;SELECT 2;END

WITH clause does not fall into the "multi statement query".

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp