psql -E option is not working in 7.4.2 like 7.3.4

[Durai raj]

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Tom Lane]

=?iso-8859-1?q?Durai=20raj?= <ma******@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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings