Hi pgsql developers:
1 . Postgres 9.1, database server OS platform: Linux x86_64 and Windows XP Professional Version 2002 SP3 Client OS platform: Linux x86_64 , Windows XP Professional Version 2002 SP3, Windows Server 2003 Standard Edition SP2 2. pgAdminIII: version 1.14.3, or the default version of Postgres 9.1 Windows x86_32 Steps: 1. Install Postgres 9.1 for Windows x86_32 2. Install the Spatial Extension for Postgis 2.0 by Stack Builder after installing Postgres 9.1 3. Restart my computer. 4. Start pgAdminIII immediately after restart , pgAmin3 is the default version of PG9.1, and then connect to the pg server by pgadmin3. 5. Run the SQL query: "SELECT setting FROM pg_settings WHERE name = 'bytea_output'; " in pgAdmin3. It will show you the value 'escape'. 6. Run the client application 'psql' to connect to the same DB server and database with the same user account. And in psql interactive terminal, run the same SQL: "SELECT setting FROM pg_settings WHERE name = 'bytea_output'; ". It will show you the value 'hex', NOT the previous value 'escape'. 7. That means, the same environment, the same SQL query, but different output. And I don't touch the file <postgresql.conf> any more ever before. Is this a bug of pgAdmin3? Thanks, Jinwei CONFIDENTIALITY NOTICE: The information contained in this message may be privileged and/or confidential. If you are not the intended recipient, or responsible for delivering this message to the intended recipient, any review, forwarding, dissemination, distribution or copying of this communication or any attachment(s) is strictly prohibited. If you have received this message in error, please notify the sender immediately, and delete it and all attachments from your computer and network.