> I would think this should echo *two* "INSERT <oid> 1" messages, instead
> of just 1.
>
> % createdb viewsdb
> CREATE DATABASE
> % psql -d viewsdb -c "create table foo(i integer); create table bar(j
> integer);"
> CREATE
> % psql -d viewsdb -c "insert into foo(i) values (1); insert into foo(i)
> values (2);"
> INSERT 9968065 1
> % psql -d viewsdb -c "select * from foo;"
> i
> ---
> 1
> 2
> (2 rows)
>
> % psql -d viewsdb -c "select oid from foo;"
> oid
> ---------
> 9968064
> 9968065
> (2 rows)
>
The query is sent as one string, and only one return is sent back. It
has always been that way.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026