Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-08-07 Thread Magnus Hagander
On Tue, Jul 31, 2012 at 9:07 AM, Guillaume Lelarge wrote: > On Tue, 2012-07-31 at 14:06 +0800, Craig Ringer wrote: >> On 07/31/2012 01:50 PM, Guillaume Lelarge wrote: >> >> Check the PgAdmin-III preferences; there may be an option to control its >> >> preferred bytea format. >> >> >> > There's no

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-31 Thread Guillaume Lelarge
On Tue, 2012-07-31 at 14:06 +0800, Craig Ringer wrote: > On 07/31/2012 01:50 PM, Guillaume Lelarge wrote: > >> Check the PgAdmin-III preferences; there may be an option to control its > >> preferred bytea format. > >> > > There's no option to control this. > > > Thanks for confirming that. > > Is

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Craig Ringer
On 07/31/2012 01:50 PM, Guillaume Lelarge wrote: Check the PgAdmin-III preferences; there may be an option to control its preferred bytea format. There's no option to control this. Thanks for confirming that. Is it really best for PgAdmin-III to have a different default than Pg its self?

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Guillaume Lelarge
On Tue, 2012-07-31 at 10:19 +0800, Craig Ringer wrote: > On 07/30/2012 11:49 AM, Emcisc (JinWei) Zhao wrote: > > 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' t

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Craig Ringer
On 07/30/2012 11:49 AM, Emcisc (JinWei) Zhao wrote: 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 accou

[BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-30 Thread Emcisc (JinWei) Zhao
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 defaul