Hi, Can you run & provide output offollowing sql queries from pgAdmin4?
- SHOW SERVER_ENCODING; - SHOW CLIENT_ENCODING; And what is the encoding set for your current database connection on which you are trying to run query (Right click on your database, click on Properties > Definition Tab > Check Encoding, Collation & Character type) ? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Jan 18, 2017 at 9:15 PM, Bhanu Gandikota <bgandik...@ebates.com> wrote: > Getting following error in PostgreSQL 9.6.1 DB logs when I tried to view > “*Scripts=>CREATE > Script*” on a table in PgAdmin4.1.1 Browser. > > PostgreSQL DB has been recently upgraded from version 9.3.9 to 9.6.1 using > pg_upgrade utility. > > > > The same browser function worked just fine when pgadmin3 was pointing to > PostgreSQL 9.3.9 database (before upgrade). > > > > > > 2017-01-18 07:34:43.364 PST,"user","QA961",5423,"x.x. > x.x:64624",587f99b8.152f,4,"idle",2017-01-18 07:24:40 > PST,2/92094,0,*ERROR,22021,"invalid > byte sequence for encoding ""UTF8"": 0x00",,,,,,"* > > SELECT t.oid,t.tgname AS name, t.xmin, t.*, relname, CASE WHEN relkind = > 'r' THEN TRUE ELSE FALSE END AS parentistable, > > nspname, des.description, l.lanname, p.prosrc, p.proname AS tfunction, > > COALESCE(substring(pg_get_triggerdef(t.oid), 'WHEN (.*) EXECUTE > PROCEDURE'), > > substring(pg_get_triggerdef(t.oid), 'WHEN (.*) \\$trigger')) AS > whenclause, > > -- We need to convert tgargs column bytea datatype to array datatype > > (string_to_array(encode(tgargs, 'escape'), > '\000')::text[])[1:tgnargs] AS tgargs, > > (CASE WHEN t.oid <= 13321::oid THEN true ElSE false END) AS > is_sys_trigger, > > (CASE WHEN tgconstraint != 0::OID THEN true ElSE false END) AS > is_constarint, > > (CASE WHEN tgenabled = 'O' THEN true ElSE false END) AS > is_enable_trigger > > FROM pg_trigger t > > JOIN pg_class cl ON cl.oid=tgrelid > > JOIN pg_namespace na ON na.oid=relnamespace > > LEFT OUTER JOIN pg_description des ON (des.objoid=t.oid AND > des.classoid='pg_trigger'::regclass) > > LEFT OUTER JOIN pg_proc p ON p.oid=t.tgfoid > > LEFT OUTER JOIN pg_language l ON l.oid=p.prolang > > WHERE NOT tgisinternal > > AND tgrelid = 17452::OID > > AND t.oid = 18252::OID > > ORDER BY tgname;",,,"pgAdmin 4 - DB:QA961" >
