id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
1830	"pgsql2shp fix for ""XInvalid endian flag value encountered"""	dfuhry2	mcayland	"pgsql2shp gives ""Invalid endian flag value encountered."" error on PostgreSQL 9.2 due to its expecting bytea_output to be in 'escape' format. At some point PostgreSQL changed the default bytea output format from 'escape' to 'hex'.

Attached patch sets server bytea_output to 'escape' while connecting, fixing the problem.

$ pgsql2shp ...
Initializing... 
Done (postgis major version: 2).
Output shape: Polygon
Dumping: XInvalid endian flag value encountered."	defect	closed	medium	PostGIS 2.0.1	loader/dumper	2.0.x	wontfix