have my problems to confirm this. Did test the logs of \testing-7.2 and the vals are written like expected.
Did fix a wrong format of the logstrings, but everything seems to be fine R2858:
Code: Select all
2013-10-21 16:38:57 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-10-21 16:38:57 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-10-21 16:38:58 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SET CLIENT_ENCODING = WIN1252
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 1
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 2
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 3
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 4
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-10-21 16:38:58 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 5
2013-10-21 16:38:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 6
2013-10-21 16:39:13 cat: Execute, proto: postgresql-9, msg: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, a.attnum AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_index i WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND i.indisprimary AND ct.relname = E'people' AND ct.relnamespace = n.oid AND n.nspname = E'public' ORDER BY table_name, pk_name, key_seq
2013-10-21 16:39:14 cat: Bind prepared, proto: postgresql-9, msg: Statement 7 : 'Kristen Sato2äöäüößßßß',3
2013-10-21 16:39:14 cat: Execute prepared, proto: postgresql-9, msg: Statement 7
2013-10-21 16:39:17 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
2013-10-21 16:39:17 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
Btw. i changed the logging a bit. Now i write the original date which we send to the server. See the accendentual characters.
