From: | "Emcisc (JinWei) Zhao" <ezhao(at)telecomsys(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Error on pg_settings.bytea_output for pg9.1 |
Date: | 2012-07-30 03:49:55 |
Message-ID: | DB3116D1C87FBA46843F046CE6DC5AC102831EF7@tj-exchange3.NIMONE.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Boris Folgmann | 2012-07-30 09:56:35 | Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY |
Previous Message | Simon Riggs | 2012-07-29 19:50:58 | Re: primary and hot standby database don' work now |