Thread: psql -E option is not working in 7.4.2 like 7.3.4

Hello All,

I built the latest postgresql 7.4.2 in HPUX PA.

The command "psql -E <databasename>", is not give the
output like in 7.3.4.

In Postgresql 7.3.4, it gives the following output:

$ echo "select * from db5;" | psql -E test
********* QUERY **********
BEGIN; SELECT usesuper FROM pg_catalog.pg_user WHERE
usename = 'postgres';
COMMIT
**************************

    name    | age
------------+-----
 James      |  25
(1 row)

But in Postgresql 7.4.2,

$ echo "select * from db5;" | psql -E test
    name    | age
------------+-----
 James      |  25
(1 row)

Why it gives diffferent output from previous version?

Regs,
Raj.






____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

=?iso-8859-1?q?Durai=20raj?= <mail_714@yahoo.co.uk> writes:
> The command "psql -E <databasename>", is not give the
> output like in 7.3.4.

-E shows the queries internally generated by psql.  The fact that these
change from version to version should not surprise you.

In this particular case, psql now has another mechanism to find out
whether you are superuser, and so it doesn't need to issue a query.
(This was part of a general effort to reduce connection startup
overhead.)

            regards, tom lane