Postgres Pro
Downloads
Home   >   mailing lists

Re: PQexec() with multiple sql statements. - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: PQexec() with multiple sql statements.
Date
Msg-id 3AD13EC7.91B74DB@tpf.co.jp
Whole thread Raw
In response to PQexec() with multiple sql statements.  ("Yasuo Ohgaki" <yasuo_ohgaki@hotmial.com>)
List pgsql-general
Tree view 
Yasuo Ohgaki wrote:
>
> Hello all,
>
> I'm would like to know how PQexec() treats query passed as its parameter.
> (PostgreSQL 7.0.3/Linux)
>

Queries in a multiple query are parsed and analyzed
at once before the execution. INSERT after CREATE
TABLE in a multiple query is impossible in 7.0.3.
Probably this is fixed in 7.1.

regards,
Hiroshi Inoue

pgsql-general by date:

Previous
From: "Willis, Ian (Ento, Canberra)"
Date:
Subject: RE: linux/bsd
Next
From: Hiroshi Inoue
Date:
Subject: Re: PQexec() with multiple sql statements.