psql -E option is not working in 7.4.2 like 7.3.4

Started by Durai rajalmost 22 years ago2 messagesgeneral
Jump to latest
#1Durai raj
mail_714@yahoo.co.uk

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Durai raj (#1)
Re: psql -E option is not working in 7.4.2 like 7.3.4

=?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